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

Export Data Table entries.

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.

PaiChungAnswer
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

View in thread

2 replies

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

Translate
    Radu15-MoonstoneAuthor
    15-Moonstone
    July 13, 2020

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

    Translate
    Terms & ConditionsAccessibility statement