cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Komi
Frequent Visitor

Get Data from cURL with Power Query

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"}}}'
6 REPLIES 6
Syndicate_Admin
Administrator
Administrator

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

Syndicate_Admin
Administrator
Administrator

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 

Please do not hijack posts. Create a new post.

lbendlin
Super User
Super User

Komi
Frequent Visitor

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

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

Helpful resources

Announcements
Exciting changes

Power BI Community Changes

Check out the changes to the Power BI Community announced at Build.

May 2023 update

Power BI May 2023 Update

Find out more about the May 2023 update.

Kudo Data Story carousel

Data Stories Gallery

Visit our Data Stories Gallery and give kudos to your favorite Data Stories.

Top Solution Authors
Top Kudoed Authors