Retrieve data for report

GET

/v1/report/{reportId}

curl --request GET \
  --url https://api.zentail.com/v1/report/1 \
  --header 'Authorization: Bearer <token>'

Retrieve report data for the supplied reportId.

Authorizations

• zentail_oauth
  legacy
• zentail_oauth
  report
• zentail_auth

Parameters

Path Parameters

reportId

required

integer

You can find the reportId in the response to posting a new Report, in a report GET response, or in the import/export UI.

Responses

200

Success

Media typeapplication/json

object

reportId

integer

label

string

isExport

If true, this is an export. Otherwise it’s an import.

boolean

requestedTs

Timestamp when the report was requested to be run.

string format: date-time

completedTs

Timestamp when the report was completed.

string format: date-time

columnTypes

Array of the column headers in this report.

Array<string>

status

string

Allowed values: PENDING PROCESSING CANCELED COMPLETE

totalLines

Total number of lines processed successfully.

integer

linesSuccessfullyProcessed

integer

filePath

Path to access the stored file. Use this to download an exported file when it is “COMPLETE”

string

errorMessage

Returns an error message if we ran into an error processing the report.

string

overwriteWithBlank

For imports only: If set to true, blank values supplied in the upload data will overwrite. NULL is equivalent to false.

boolean

createNewProducts

For imports only: If set to true, if a SKU doesn’t exist in zentail we will create one. NULL is equivalent to false.

boolean

activeOnly

For exports only: If set to true, export will only include active products.

boolean

insertOnly

For imports only: If set to true, report will only fill in blank data on Zentail. Any data that already exists on Zentail will not be overwritten by data in the file.

boolean

includeHeader

For exports only: If set to true, export will include a header

boolean

default: true

exportForExcel

For exports only: If set to true, will export as an Excel file.

boolean

filter

For exports only: Use this to pass in filters to restrict the products being exported. See how to write a filter formula here.

string

delimiter

For exports only: We will use this delimiter to separate the data in the export.

string

default: ,

headersOnly

For exports only: If true, this export will only have header rows.

boolean

uploader

If this is null, then the report was created by the API.

string

Example

{
  "isExport": false,
  "status": "PENDING",
  "overwriteWithBlank": false,
  "createNewProducts": false,
  "activeOnly": false,
  "insertOnly": false,
  "includeHeader": true,
  "exportForExcel": false,
  "delimiter": ",",
  "headersOnly": false
}

400

Bad Request

Media typeapplication/json

object

errorCode

number

errorMessages

Array<string>

referenceId

string format: uuid

Example

{
  "errorCode": 400
}

403

Permission Denied

Media typeapplication/json

object

errorCode

number

errorMessages

Array<string>

referenceId

string format: uuid

Example

{
  "errorCode": 403
}

404

Not Found

Media typeapplication/json

object

errorCode

number

errorMessages

Array<string>

referenceId

string format: uuid

Example

{
  "errorCode": 404
}

500

Zentail Error

Media typeapplication/json

object

errorCode

number

errorMessages

Array<string>

referenceId

string format: uuid

errorMessage

string

Example

{
  "errorCode": 500
}

503

Zentail Error

Media typeapplication/json

object

errorCode

number

errorMessages

Array<string>

referenceId

string format: uuid

Example

{
  "errorCode": 503
}