curl --request GET \
--url https://api-dev.narrative.io/jobs \
--header 'Authorization: Bearer <token>'{
"records": [
{
"job_id": "2a5b9ad7-dc8f-47bb-8e62-843a38f8054c",
"request_source": {
"type": "api_user",
"company_id": 1,
"user_id": 407
},
"state": "completed",
"type": "materialize-view",
"input": {
"nql": "CREATE MATERIALIZED VIEW \"test_stats\" AS SELECT \"value\" FROM \"company_data\".\"10674\"",
"dataset_id": 10736,
"stats_enabled": true,
"compiled_select": "SELECT\n `ds_10674`.`value`\nFROM\n narrative.datasets.ds_10674 `ds_10674`"
},
"executor": "job-executor-98e1f48e-bf54-4f11-bbd1-73c445120266",
"idempotency_key": "10736:29329c64e7b8a4eda86aaabe04872b832ab456b5543d0c259c812525391f158c:669a5f8e4f373c2f907700decde47511aac6470f5698e2b856fb07f09160e5f2",
"result": {
"dataset_id": 10736,
"snapshot_id": 1724919539450264600,
"recalculation_id": "abf9a2ec-426b-4751-bd16-fcb435061925"
},
"created_at": "2023-10-31T11:19:13.400498",
"updated_at": "2023-10-31T11:25:08.327209",
"ended_at": "2023-10-31T11:25:08.327194"
}
]
}Returns a list of jobs associated with the specified company, including job ID, job type, timestamp information, and results.
It returns a maximum of 500 jobs at a time to manage response size.
curl --request GET \
--url https://api-dev.narrative.io/jobs \
--header 'Authorization: Bearer <token>'{
"records": [
{
"job_id": "2a5b9ad7-dc8f-47bb-8e62-843a38f8054c",
"request_source": {
"type": "api_user",
"company_id": 1,
"user_id": 407
},
"state": "completed",
"type": "materialize-view",
"input": {
"nql": "CREATE MATERIALIZED VIEW \"test_stats\" AS SELECT \"value\" FROM \"company_data\".\"10674\"",
"dataset_id": 10736,
"stats_enabled": true,
"compiled_select": "SELECT\n `ds_10674`.`value`\nFROM\n narrative.datasets.ds_10674 `ds_10674`"
},
"executor": "job-executor-98e1f48e-bf54-4f11-bbd1-73c445120266",
"idempotency_key": "10736:29329c64e7b8a4eda86aaabe04872b832ab456b5543d0c259c812525391f158c:669a5f8e4f373c2f907700decde47511aac6470f5698e2b856fb07f09160e5f2",
"result": {
"dataset_id": 10736,
"snapshot_id": 1724919539450264600,
"recalculation_id": "abf9a2ec-426b-4751-bd16-fcb435061925"
},
"created_at": "2023-10-31T11:19:13.400498",
"updated_at": "2023-10-31T11:25:08.327209",
"ended_at": "2023-10-31T11:25:08.327194"
}
]
}Bearer authentication header of the form Bearer <token>, where <token> is your auth token.
Filter jobs by data plane ID.
Filter jobs where the input has a dataset_id (such as materalized-view)
Number of records to skip (page_number * per_page).
Order the results by a specific field. By default, job are order by created_at in descending order.
created_at_asc, created_at_desc Number of records to return.
Filter jobs by state.
cancelled, completed, failed, pending, pending_cancellation, running Filter jobs by type.
OK
Show child attributes