Stripe Rest API integration with ADF

Ravi Kumar 6 Reputation points
2022-03-29T20:09:41.983+00:00

Hi,

we did the Stripe Rest API integration using ADF to load data into Azure Synapse Datawarehouse.
as stripe has a max limit per iteration is 100 records hence to get required records try to add another parameter in the "web". Parameter value supposes to get replaced from lookup data as below.

Unfortunately, in Azure Data Factory pipelines, it looks like parameters are not being substituted for the intended values during the pipeline process.

{
limit: "100",
key: "sk_live_N5******************Kj8s",
starting_after: "@(activity('pipeline3_test_lookup').output.value)"
}

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
9,896 questions
{count} vote

1 answer

Sort by: Most helpful
  1. HimanshuSinha-msft 19,386 Reputation points Microsoft Employee
    2022-03-31T19:20:04.307+00:00

    Hello @Ravi Kumar ,
    Thanks for the question and using MS Q&A platform.
    As we understand the ask here is to make a successful call to the Stripe REST API , please do let us know if its not accurate.
    From your ask it is clear that you are reading the value for "starting_after" from alooup and passing that to the request of the WEB API .
    I could suggest you to please

    1. Create one variable actvity and assign that variable the value @(activity('pipeline3_test_lookup').output.value) and check if you are getting the correct value
    2. I think you are passing the json as the body of the request , so please create a variable activity and try to create a JSON object
      @markus.bohland@hotmail.de ('{ limit: "100",key: "sk_live_N5**Kj8s", starting_after":', string(activity('pipeline3_test_lookup').output.value))."}"_
      and pass the variable in the body of the request .

    188880-image.png

    Please do let me if you have any queries.
    Thanks
    Himanshu


    • Please don't forget to click on 130616-image.png or upvote 130671-image.png button whenever the information provided helps you. Original posters help the community find answers faster by identifying the correct answer. Here is how
    • Want a reminder to come back and check responses? Here is how to subscribe to a notification
      • If you are interested in joining the VM program and help shape the future of Q&A: Here is how you can be part of Q&A Volunteer Moderators
    0 comments No comments