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.
Authorization required | string Example: Bearer api-secret |
{- "id": "12ab5182-jh73-9876-b77e-e71235a123a0",
- "name": "Awesome table",
- "globalType": "",
- "columns": [
- {
- "label": "Question",
- "dataType": "string",
- "columnType": "TEXT"
}, - {
- "label": "Answer",
- "dataType": "float",
- "columnType": "NUMBER"
}
]
}
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.
dataTableId required | string Example: dataTableId=12ab5182-jh73-9876-b77e-e71235a123a0 |
Authorization required | string Example: Bearer api-secret |
{- "next": "next.com,",
- "totalCount": "2,",
- "data": [
- {
- "Question": "The Ultimate Question of Life, the Universe, and Everything",
- "Answer": 42,
- "_rowId": "1"
}, - {
- "Question": "What is 6 times 7?",
- "Answer": 42,
- "_rowId": "2"
}
]
}
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.
dataTableId required | string Example: dataTableId=12ab5182-jh73-9876-b77e-e71235a123a0 |
Authorization required | string Example: Bearer api-secret |
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 |
{- "size": 10000,
- "columnFilter": {
- "columnLabels": [
- "string"
], - "columnTypes": [
- "TEXT"
]
}, - "lastModifiedDateFilter": {
- "gte": "now-1M",
- "lte": "2030-10-31"
}
}
{- "next": "next.com,",
- "totalCount": "2,",
- "data": [
- {
- "Question": "The Ultimate Question of Life, the Universe, and Everything",
- "_rowId": "1"
}, - {
- "Question": "What is 6 times 7?",
- "_rowId": "2"
}
]
}