Insert arguments into Rest dataset

Dave Gray 581 Reputation points
2023-02-20T13:55:52.92+00:00

Hi

I have a linked service (ServiceNow) which I assume is just using a Rest API. Had a look around for docs on using this linked service but I cannot find any. Also asked on the ServiceNow forums but got no answers.

What I am wondering is how I can inject arguments into the dataset/pipeline in ADF for things like paging. As an example in Postman a parameter/argument would be sys_parmquery=number=INC1234.

How would I insert this into my ADF dataset or pipeline?

Thanks in advance.

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
10,567 questions
{count} votes

Accepted answer
  1. HimanshuSinha-msft 19,471 Reputation points Microsoft Employee
    2023-02-21T21:30:26.77+00:00

    Hello @Dave Gray ,

    Thanks for the question and using MS Q&A platform.
    I was looking at the document for ServiceNow implementation on ADF here and I see that we do refer to tables and if you know the table name, then you should be able to get all the records from ServiceNow. Yes, the API, which is being called in is not exposed.

    User's image

    Just in case if you still want to query the data with a REST API , the please use the REST connector > https://learn.microsoft.com/en-us/azure/data-factory/connector-rest?tabs=data-factory

    Let me know if you have any further questions.

    Thanks
    Himanshu

    Please accept as "Yes" if the answer provided is useful , so that you can help others in the community looking for remediation for similar issues. 

    1 person found this answer helpful.

0 additional answers

Sort by: Most helpful

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.