Classic file types are no longer available for use as of January 2021. You can transition your classic files or download a PDF. Learn More

Run Query Errors

Answered
0

Comments

3 comments

  • Official comment
    Wayne Paffhausen

    Hello Leonard Hughes,

    I'm a bit confused on your request.  Are you trying to do something with the API via a tool like PostMan or are you asking to solve for Run Query?

    To solve for RunQuery it appears you have not adequately generated an Oauth2 grant per the documentation and configured it for the Workiva connector.  I would suggest the following:

    1. Ensure you have an OAuth2 grant setup per the docs:  https://developers.workiva.com/workiva-platform/reference/platform-setup
    2. Ensure that the information for the User Created has access to the artifacts you are using inside of Wdata
    3. Ensure that the ClientID / ClientSecret are specified inside of the Chains Connector per the docs: https://support.workiva.com/hc/en-us/articles/360045097312

    Please kindly let us know if you are still getting any errors.  Please paste the full details of the LOGS tab from within chains.

  • Leonard Hughes
    🔌 Workiva BizApp1.0.0 
     
    ⚙️ Run Query Configuration:  
            Admin Host Override: https://api.app.wdesk.com/admin/v1 
             Run Asynchronously: false 
                      Client ID: 3760f8517255452aa3f8742193ee67e6 
                  Client Secret: ENCRYPTED 🔐 
         Graph DB Host Override:  
                       Query ID: https://h.app.wdesk.com/s/wdata/a/QWNjb3VudB82NTQwMzgyODk4ODgwNTEy/queries/8c17c115822547d98ba4d36960c789a5 
            Multi-select Params: [] 
                         Params: [{"key":"Previous_Year","value":"2019"},{"key":"Current_Year","value":"2020"},{"key":"Current_Period","value":"3"}] 
     
    Command description: Runs a query and immediately returns a query result entity. This entity has an id that can be used to download to export the results. 
     
     
    Error authenticating with Workiva: unknown error (status 403): {resp:0x9ca2000}  
     
    Result: Error authenticating with Workiva: unknown error (status 403): {resp:0x9ca2000}  
     
    0
  • Leonard Hughes

    Workiva has its own API correct? So where do I need to input this "https://developers.workiva.com/workiva-wdata/reference/wdata-authentication" documentation to be able to connect with it? DO I need to create a chain element to be able to house the authentication requests?

     

    Thanks for the help, im having issues with both the authentication and the run query. I wasnt sure if they were both related.

    0

Please sign in to leave a comment.