REST API : Need help to fill out Base URL and Token endpoint

Question

REST API : Need help to fill out Base URL and Token endpoint

Anonymous

I am trying to fill out these areas inside Azure Data Factory's REST API linked service:

Base URL & Token endpoint

I have these information given from API source:

----------------------------------------------------------------------------------------------------------------

We have completed the isolved setup for the MyCompany API testing.

URL: https://snfpayroll.myisolved.com/ (see attached instructions for more information!)
API Client ID: 7b9f39fd..........be...a393
API Secret: 2bkFFe8rcts.......................khGIq6Qu

Access to our Swagger site for the HCM REST API: (access is limited to SB, client and/or vendor covered by the NDA)

URL: https://myisolved.com/rest
API Client ID: c329a0..................7ce40c

---------------------------------------------------------------------------------------------------------------------

I also have other documentation shown as below:

Thank you for help.

ShaikMaheer-MSFT 38,546 Reputation points Microsoft Employee Moderator

2022-11-29T14:25:47.713+00:00

Hi @Anonymous ,

Just checking in to see if the below answer helped. If this answers your query, do click and upvote for the same. And, if you have any further query do let us know.

1 answer

Your answer

ShaikMaheer-MSFT 38,546 Reputation points Microsoft Employee Moderator

2022-11-29T14:25:47.713+00:00

Hi @Anonymous ,

Just checking in to see if the below answer helped. If this answers your query, do click and upvote for the same. And, if you have any further query do let us know.

Answer 1

ShaikMaheer-MSFT 38,546 Microsoft Employee Moderator

Hi @Anonymous ,

Thank you for posting query in Microsoft Q&A Platform.

From your screenshot it seems in the Toke endpoint field you are using API URL itself, you should consider using token end point of the authorization server to acquire the access token.

Kindly consider using https://www.myisolved.com/rest/api/token as Token endpoint` URL and see if that helps?

Please let me know how it goes. Please share error details if any. Thank you.

Anonymous

2022-11-02T18:15:38.853+00:00

@ShaikMaheer-MSFT
Thank you for your help.
I think I got the Token using Postman.
Now, I tried filling this area (Base URL), and got this error when I test connection.
ShaikMaheer-MSFT 38,546 Reputation points Microsoft Employee Moderator

2022-11-03T09:42:46.237+00:00

Hi @Anonymous , Since you already have token then you no need to use OAuth Authentication here. Kindly use authentication as basic and in username field use any dummy value and in Password field use your token. Also in base URL filed use https://www.myisolved.com/rest/api/client

Hope this helps.

---------
Please consider hitting Accept Answer button. Accepted answers help community as well.
Anonymous

2022-11-03T22:24:12.65+00:00

@ShaikMaheer-MSFT
Thank you so much for getting back to me and for your feedback.
I tried using the basic, and connection is working. That is great!

But now, I am trying to preview data, and I am getting an error (see below for details).

I am not sure what I am trying to get thru API though.
How do I indicate something like table name or source dataset?
ShaikMaheer-MSFT 38,546 Reputation points Microsoft Employee Moderator

2022-11-17T04:14:54.57+00:00

Hi @Anonymous , It says 404 error. That means the resource to which we are making API call its not available. Could you please check if you are using correct URL and also correct HTTP method? Also, try to make same API call using third party tools like postman and see if its working there?

Feel free to share your API call details from postman also from ADF activity settings. that way we can compare and see where its causing issue.

-----------

Please consider hitting Accept Answer button. Accepted answers help community as well.

Share via

REST API : Need help to fill out Base URL and Token endpoint

1 answer

Your answer