This API request is initiated with an GET
to the following URL:
http://quickfuseapps.com/api/1/sdb/download/csv/<tablekey>
Replace <tablekey>
with the table to be downloaded. For more information on this parameter, see the Parameters section.
Basic example: Downloads all data from the table customers
owned by the user.
$ curl -u 'username:password' 'http://quickfuseapps.com/api/1/sdb/download/csv/username:customers'
This example returns a CSV document.
<tablekey>
(string) - Identifies the table to be downloaded. This is in the format <tableowner>:<tablename>
. It is case and whitespace sensitive. <tableowner>
is the full username of the owner of the table. Valid table names contain only letters, numbers, and the underscore _ character.There is little consensus over what constitutes a valid CSV since the format was used informally long before it was formally specified in 2005; therefore, the following is a description of the CSV format that our webservices understand. As much as possible, we've followed the Basic Rules that most CSV parsers implement, which is also the format that Microsoft Excel exports and imports most easily.
The following is an example response when the download has successfully completed. The data shown is representative of a small Simple Database table with 5 columns and 7 rows of data.
Important: This response will be in CSV format, and not in JSON.
question1,question2,outbound_result,phone_number,name yes,yes,success,2125551234,bob no,yes,success,6175551412,larry ,,,,invalid yes,yes,,6175554123,jonathon ,,,6175553154,jerry ,,,6175554773,vicky yes,yes,,6175552413,samuel
This webservice will only issue a JSON response if there was an error, and its format will be typical of other error responses.