API Reference

Retrieve a list of files

Description

Returns a paged list of all files associated with the provided table ID, as well as metadata associated with each file.

GET /api/v1/file

🚧

Required OAuth Scopes:

No OAuth scopes are required to use this endpoint.

Parameters

ParameterInTypeRequiredDescription
tableIdquerystringtrueThe unique table identifier associated with this file
limitqueryinteger(int32)falseThe number of files to return, from 1 to 1000; by default, 1000
cursorquerystringfalseA paging cursor; if included, limit is ignored
offsetqueryinteger(int64)falseThe item to start with on the page, greater than or equal to 0; by default, 0
sortOrderquerystringfalseThe sort order for the files being returned
sortByquerystringfalseThe column to use the sort order on
searchTextquerystringfalseThe text to filter the results upon; matching the file name

Enumerated Values

ParameterValue
sortOrder[asc
sortOrderdesc]
sortBy[name
sortBydate]

Code Samples

curl -X GET https://h.app.wdesk.com/s/wdata/prep/api/v1/file  \ 
-H 'Accept: application/json' \ 
-H 'Authorization: Bearer {access-token}' -G \ 
--data-urlencoded "tableId=string"
http GET https://h.app.wdesk.com/s/wdata/prep/api/v1/file  \ 
Accept:application/json \ 
Authorization:"Bearer {access-token}" \
tableId==string
wget --method=GET "https://h.app.wdesk.com/s/wdata/prep/api/v1/file?tableId=string" \
 --output-document -  \ 
 --header 'Accept: application/json' \ 
 --header 'Authorization: Bearer {access-token}'
import requests
headers = {
  'Accept': 'application/json',
  'Authorization': 'Bearer {access-token}'
}

r = requests.get('https://h.app.wdesk.com/s/wdata/prep/api/v1/file', params={
  'tableId': 'string'
}, headers = headers)

print(r.json())

Returns

200 - OK

Returns a JSON object with body and cursor properties.

  • body contains an array of FileMetaDto objects. If the request returns no results, body contains an empty array.
  • cursor contains a paging cursor, which can be included in the next call to the endpoint to retrieve the next set of results. If no additional results, cursor is null.

Example Responses


{
  "body": [
    {
      "columnMappings": {},
      "created": "string",
      "delimiter": "string",
      "id": "string",
      "key": "string",
      "metadata": {},
      "name": "string",
      "numErrors": "integer",
      "numRecords": "integer",
      "originalFileSize": "integer",
      "source": "string",
      "status": "string",
      "tableId": "string",
      "tags": {},
      "updated": "string",
      "userId": "string",
      "version": "integer"
    }
  ],
  "code": "integer",
  "cursor": "string"
}