topic Re: Set variable from copy data JSON output - correct syntax? in Pipelines

Set variable from copy data JSON output - correct syntax?

heidik — Thu, 27 Jul 2023 06:57:53 GMT

Hi!

I'm trying to create a pipeline that reads Power BI REST APIs and I would like to store the token I get in my first call in a variable to use it later in the authorization step for the next API call. But I'm having a hard time understanding what would be the correct syntax to get the value out from the first copy data that is in a JSON format. Any advice of the syntax or a link to documentation/tutorials how it should be build? 🙂 Or am I doing something completely wrong here? 😄 Thanks!

Re: Set variable from copy data JSON output - correct syntax?

GraceGu — Thu, 27 Jul 2023 07:39:08 GMT

Can you check whether this blog Data Pipelines Tutorial: Ingest files into a Lakehouse from a REST API with pagination ft. AVEVA Data Hub | Microsoft Fabric Blog | Microsoft Fabric can help?

Re: Set variable from copy data JSON output - correct syntax?

heidik — Thu, 27 Jul 2023 08:20:31 GMT

Awesome thank you GraceGu I found the solution there! I was using a copy data to get the token but in the tutorial it's just a Web call to get the token that then returns working JSON structure that is easy to read to a variable 🙂