cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

Community Tip - Want the oppurtunity to discuss enhancements to PTC products? Join a working group! X

Export Data Table entries.

Radu
15-Moonstone

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.

ACCEPTED SOLUTION

Accepted Solutions
PaiChung
22-Sapphire I
(To:Radu)

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 solution in original post

2 REPLIES 2
PaiChung
22-Sapphire I
(To:Radu)

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

Radu
15-Moonstone
(To:PaiChung)

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

Announcements


Top Tags