Ignite procurement export API (2.0.0)

Download OpenAPI specification:Download

Exporting data from Ignite Procurement. Note: JSON web tokens are no longer supported. Please get a new api token and switch to Bearer authorization.

List all data tables and their data columns

header Parameters
Authorization
required
string
Example: Bearer api-secret

Responses

Response samples

Content type
application/json
{
  • "id": "12ab5182-jh73-9876-b77e-e71235a123a0",
  • "name": "Awesome table",
  • "globalType": "",
  • "columns": [
    ]
}

Extract rows from data table

Extract all rows from data table 10 000 pr iteration. Each entry in the data property of the response will be an object consisting of key value pairs, where the key will be the label of the corresponding column.

query Parameters
dataTableId
required
string
Example: dataTableId=12ab5182-jh73-9876-b77e-e71235a123a0
header Parameters
Authorization
required
string
Example: Bearer api-secret

Responses

Response samples

Content type
application/json
{
  • "next": "next.com,",
  • "totalCount": "2,",
  • "data": [
    ]
}

Extract rows from data table

Extract all rows from data table 10 000 pr iteration. Each entry in the data property of the response will be an object consisting of key value pairs, where the key will be the label of the corresponding column.

query Parameters
dataTableId
required
string
Example: dataTableId=12ab5182-jh73-9876-b77e-e71235a123a0
header Parameters
Authorization
required
string
Example: Bearer api-secret
Request Body schema: application/json

Optional body for filtering rows and/or columns

size
integer

Number of rows to extract pr iteration. Max 10 000

object

For filtering out unwanted columns of the table

object

For extracting rows based on when they were last modified in Ignite. Accepted formats: YYYY-MM-DD or realtive date queries like now-1M (today minus one month). Accepted units: y = Years, M = Months, w = Weeks, d = Days, h = Hours, H = Hours, m = Minutes, s = Seconds

Responses

Request samples

Content type
application/json
{
  • "size": 10000,
  • "columnFilter": {
    },
  • "lastModifiedDateFilter": {
    }
}

Response samples

Content type
application/json
{
  • "next": "next.com,",
  • "totalCount": "2,",
  • "data": [
    ]
}