Forum Discussion
Anonymous
5 years agoNot applicable
Get Results from API
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.
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
1 Reply
- mahoneypatMicrosoft Employee
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