Community Tip - Visit the PTCooler (the community lounge) to get to know your fellow community members and check out some of Dale's Friday Humor posts! X
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.
Solved! Go to Solution.
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
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
Thanks for the help. The third solution helped me the most.