Platform

Platform

A place for Apptio product users to learn, connect, share and grow together.

 View Only

  • 1.  Connector execute - from API call is throwing 500 error

    Posted 03/18/22 09:22 AM
    Hi Experts,

    We are new to Apptio and created the connector by using DataLink classic using the file share path from the on-prem agent. When I tried to execute the connector using the API call from Swagger UI as testing by providing the agent id and connector id, getting 500 errors. 
    can't parse JSON.  Raw result:

500 Internal Server Error
    Please guide me , how to fix the issue.
    #TBMStudio


  • 2.  RE: Connector execute - from API call is throwing 500 error

    Posted 03/18/22 10:38 AM

    Hi Venkateswara,

    The swagger page only includes a sample "string" in the message body.  The execute API is expecting this JSON body instead

    {"task": "ExecuteConnector"}

    Let me know if that resolves the issue .

    Regards,
    Brandon Porter
    Technical Architect
    Apptio




  • 3.  RE: Connector execute - from API call is throwing 500 error

    Posted 03/18/22 10:57 AM
    Hi Brandon,

    Thank you for the response. and I tried adding the {"task": "ExecuteConnector"} statement in Jason Body, after that i am getting 401 error.
    401 Error: Unauthorized
    Response headers
     connection: keep-alive  content-length: 0  date: Fri, 18 Mar 2022 14:56:32 GMT  strict-transport-security: max-age=31536000;includeSubDomains  via: 1.1 hybrid.websense 09nyca  x-bst-info: t=1647615392,h=09nyca,p=214273_5600:1_2510,u=2858370945,c=6264,v=7.11.200100.64  x-bst-request-id: G3gxDj:gvP:52548

    Original Message


  • 4.  RE: Connector execute - from API call is throwing 500 error

    Posted 03/18/22 11:18 AM
    Hi Venkateswara,

    The swagger page assumes your browser has authenticated on the frontdoor authentication portal with a role that allows access to the API (your username has a correct role for this).  Please log into frontdoor.apptio.com, then retry the swagger query.  The default duration for frontdoor authentication tokens is 1 hour.  

    Regards,
    Brandon
    Original Message


  • 5.  RE: Connector execute - from API call is throwing 500 error

    Posted 03/18/22 11:52 AM
    Thank You!! Brandon. It worked, But when automating through third-party scheduler, how to mention the josn statement {"task": "ExecuteConnector"} in scheduling tool. 
    Original Message


  • 6.  RE: Connector execute - from API call is throwing 500 error

    Posted 03/18/22 04:16 PM

    Hi Venkateswara,

    Covering the implementation of a 3rd party scheduler is probably beyond the scope of a community posting.  If you have not already done so, I encourage you to bring this up with your Apptio CSM or implementation consultant to see if there is a way for Datalink Classic or Datalink to meet your use case.  If not, you will need to integrate the following into your scheduler: 

    - Frontdoor authentication via the frontdoor API which will be passed in the Datalink API as a header.  The swagger page for frontdoor is https://frontdoor.apptio.com/swagger#. 
    See these articles for more information.  
     --- https://help.apptio.com/en-us/frontdoor/admin-guide/api/overview-api-keys-faq.html
     --- https://help.apptio.com/en-us/studio/studio/apis/studio_tutorial.htm (The earlier sections ofthis explain how to use the API to get an auth token)

    - Datalink Classic API.  There are some sample scripts here that may be helpful in addition to the swagger page.  The token returned from the frontdoor authentication above will be used in the Datalink Classic API as a header with key "apptio-opentoken" and value <the generated frontdoor token> 
     --- https://help.apptio.com/en-us/datalink-classic/api-dlc-sample-scripts.html?Highlight=api

    Regards,
    Brandon


    Original Message


  • 7.  RE: Connector execute - from API call is throwing 500 error

    Posted 03/18/22 09:01 PM
    Hi Brandon, Thank you for the guidance. I will try the options.
    Original Message


Related Content