Get Data from cURL with Power Query

[Komi]

Hi, I need help - I have a cURL and I need to transform it into a power query.

Can someone please help me?

curl --request POST \
  --url https://api.abcd.com/2/ \
  --header 'accept: application/json' \
  --header 'content-type: application/json' \
  --header 'authorization: Bearer xyz' \
  --data '{"query":"query ($period: PeriodFreeInput!) { workspace (id:  \"2ihQOg3IwTBE\") { shifts ( period: $period ) { userName, userId, workTime, period { start, end }, user { email } } } }\n\n","variables":{"period":{"start":"2022-03-31T22:00:00.000Z","end":"2022-04-30T21:59:59.999Z"}}}'

[Syndicate_Admin]

sorry I didn't know that. I will create a new post. 

[Syndicate_Admin]

Hello 

I have an intranet website that has a button to download a file in CSV. 

Can I use power BI to trigger this function in the website to fetch the CSV file and transform it into a table I can manipulate later? If it is doable what info you might need from me to help me? thank you 

[lbendlin]

Please do not hijack posts. Create a new post.

[lbendlin]

Web.Contents - PowerQuery M | Microsoft Docs

Example 2

[Komi]

Thanks, I've been looking at it, unfortunately I don't know how to write the query part. 😞

[lbendlin]

Without access to your API it is not possible to help you further. You can use Postman or similar for developing the required format.