Mar 29 2022 10:27 AM
Any help here would be greatly appreciated. I'm Director of Revenue Management for a hotel company and have been using queries to pull API competitive shop date into the workbook used for forecasting and rate analysis.
I've been informed by our shop vendor, OTA Insight, that they are changing how the API works. Up to now, they've used a simple URL with my authentication token as part of the URL. For example, the current URL for the query looks like this:
https://api.otainsight.com/v2/rates?token=MyToken&subscriptionId=MyID&ota=branddotcom&changeDays=2,5,7&shopLength=90&format=csv
They're requiring a move to this, but everything I've tried thus far results in an invalid URL message from Excel:
curl -H "X-Oi-Authorization: <MyToken>" https://api.otainsight.com/v3/rates...rue&changeDays=3,5,7&shopLength=90&format=csv
So, how can I implement his in Excel so I can continue to pull API shop data into Excel directly?
Thanks much!
Mar 30 2022 03:33 PM
Not looking good for an answer here. If no one here knows, probably explains why I'm not getting any replies from the vendor about the API changes...
Apr 01 2022 06:59 AM
Apr 14 2022 12:23 PM