Get Results from API

[Hash_001]

I have API https://prehubapi.hashmove.com/api/general/GetGuestUserBookingURL/ and I want to pass booking id in this API like https://prehubapi.hashmove.com/api/general/GetGuestUserBookingURL/[Booking_ID]

for a sample https://prehubapi.hashmove.com/api/general/GetGuestUserBookingURL/100

how to get results using power query.

[mahoneypat · Accepted solution]

Convert your booking ID column to text, and then you can add a custom column like this to do that.

= Web.Contents("https://prehubapi.hashmove.com/api/general/GetGuestUserBookingURL/" & [Booking_ID]

Pat