Skip to main content
R
Radu15-Moonstone
15-Moonstone
July 13, 2020
Solved

Export Data Table entries.

  • July 13, 2020
  • 1 reply
  • 2487 views

Hello.

 

I have a Data Table thing that has 800 entries. How can I export all these entries into a .CSV format, such that it can be properly read by a spreadsheet program?

 

Thank you.

Best answer by PaiChung

You can use a direct url call <Server>/Thingworx/DataTables(or maybe it is Things)/NameOfDataTable/Services/GetDataTableEntries this would be a post and then set the return type to text/csv

 

You can also call it internally as a service and save it to the File repository as a CSV

 

You can call it into  a mashup and use the Data Export widget to export it as a CSV

1 reply

P
PaiChung22-Sapphire IAnswer
22-Sapphire I
July 13, 2020

You can use a direct url call <Server>/Thingworx/DataTables(or maybe it is Things)/NameOfDataTable/Services/GetDataTableEntries this would be a post and then set the return type to text/csv

 

You can also call it internally as a service and save it to the File repository as a CSV

 

You can call it into  a mashup and use the Data Export widget to export it as a CSV

    R
    Radu15-MoonstoneAuthor
    15-Moonstone
    July 13, 2020

    Thanks for the help. The third solution helped me the most.

    Terms & ConditionsCookie settingsAccessibility statement