SNOW Connection - OAUTH2.0 in Aperture

Mahulima
Mahulima Contributor
edited July 25 in Say hello

@henry_ @Henry Simms @Josh Boxer

We are trying to Build the External System connection through API in Aperture, the authentication method is OAuth 2.0

I am able to get the response in Postman and also able to Download the JSON file and then process the Same in Aperture, then i can see the Table and also the records. But with Progress Data Direct I am not getting the response file

Can you please help and suggest

@KatriM

Tagged:

Answers

  • KatriM
    KatriM Member

    @Henry Simms @Josh Boxer So Service Now is the source here, do you have experience about connecting to Service Now? How would you suggest to do that if we cannot get that Autonomous Rest 6.0 connector to work with OAUTH2?

  • Mahulima
    Mahulima Contributor
    edited June 17

    @Henry Simms @henry_ @Josh Boxer

    Another observation:

    When in Progress Data Direct we tried with OAuth2 , Fetch Auth Token is giving us error

    "{"error_description":"access_denied","error":"server_error"}"

    Basic and OAuth2 Both Authentication Type: In the Configuration Endpoint tab we can see the List of the End Points but no data and when we Send the GET Endpoint on which we have access we are getting the below Error

    MicrosoftTeams-image (14).png

  • Mahulima
    Mahulima Contributor

    Any Suggestion on this will be highly appreciated :) We are now stuck to integrate with SNOW as Source System.

    We are getting response in Postman with Both Authentication Method 1. Basic 2. OAuth 2.0 But in Progress Data Direct we are not able to get the response, also then need some suggestion how to configure this in ADS external System Settings. We are now set up like this

    snow_ext.JPG

    @Juhana

  • Henry Simms
    Henry Simms Administrator

    For future reference there's a guide here to connecting to ServiceNOW with the AutoREST connector using OAuth2: https://community.experianaperture.io/discussion/1334/connecting-to-the-servicenow-rest-api-using-oauth2

  • Mahulima
    Mahulima Contributor

    @Henry Simms

    I have also commented on the link you shared. The Guide has the Output which has only 21 columns of the table and that too system columns. Now in our case also I am able to get exactly 21 columns and those are system columns. Please check the guide once I think there also it has limitation in the example.

  • Henry Simms
    Henry Simms Administrator

    Hi @Mahulima - Sure, I'm aware of that question and I should have an answer on here for the table columns later today

  • Mahulima
    Mahulima Contributor

    @Henry Simms Thank You! :) I will be waiting for your Guidance

Categories