7 Replies Latest reply on Apr 2, 2020 7:15 AM by Robert Bress

    Unable to query Job via REST API for incremental refresh

    Robert Bress

      Hello, I am unable to query a job ID (see step 2. below) via the REST API (version 3.0) for an incremental refresh after running an extract refresh task.


      Can someone kindly assist with how I can successfully query a job for an incremental refresh?


      Please note that the below call works for full refreshes. The team is using Tableau Server version 2018.1.


      1.) Extract refresh task API Call:

      Reference: https://help.tableau.com/v2018.1/api/rest_api/en-us/help.htm#REST/rest_api_ref.htm#Run_Extract_Refresh_Task

      POST /api/api-version/sites/site-id/tasks/extractRefreshes/task-id/runNow


      {'job': {'extractRefreshJob': {'workbook': {'id': '7f2e35c9-f4cc-4bbb-a4ca-2f857f47a650', 'name': 'revenue'}}, 'id': '478aa623-0909-4492-8d6d-203e7479f87a', 'mode': 'Asynchronous', 'type': 'RefreshExtract', 'createdAt': '2020-02-21T13:07:42Z'}}


      2.) Query Job API Call:

      Reference: https://help.tableau.com/v2018.1/api/rest_api/en-us/help.htm#REST/rest_api_ref.htm#Query_Job%3FTocPath%3DAPI%2520Referen…


      GET /api/api-version/sites/site-id/jobs/job-id

      Response (for incremental refreshes only):

      {'error': {'summary': 'Bad Request', 'detail': "There was a problem querying job '478aa623-0909-4492-8d6d-203e7479f87a'.", 'code': '400031'}}


      Any assistance would be greatly appreciated. Thank you!