Complex Data Structures:
For complex structures with lots of sub-forms, you should manage your downloads in two different steps. You should create a script that looks first for the new record IDs to download, and then download each record one at a time.
To figure out which records to download, you can use TYPE=ID and either SINCE_ID, or SINCE_DATE to determine which records you need to pull down. Once you have the list of IDs then you can go about downloading each one.
Step One- This produces a list of all the new records that you will want to download. Based on the URL below, the results returned 4 records (101, 102, 103, 104)
&TABLE_NAME=_data99999_data_feed_test&TYPE=ID&SINCE_ID=100
Step Two- Now you can run queries on each new record from your list one at a time.
&TABLE_NAME=_data99999_data_feed_test&ID=101
&TABLE_NAME=_data99999_data_feed_test&ID=102
&TABLE_NAME=_data99999_data_feed_test&ID=103
&TABLE_NAME=_data99999_data_feed_test&ID=104
Comments
3 comments
How can we download csv file(export data) using API in JAVA or php?
Can please write down the complete URL???
Hi there, we do not provide a CSV format, rather Excel, XML, JSON, RSS! And ATOM. The full URL will be different depending on your account / form. You can get the details from the Data tab under your account.
Hope that helps,
Tony
Please sign in to leave a comment.