Hi,
I am currently trying to build a model, which requires me to import some data (91.000 rows) from an external website via API.
The API-key I have been provided with is:
api.dabas.com/DABASService/V2/articles/XML?apikey=2ad1a988-bd2c-4aa7-afa9-048bfa592229[/url]
The API gives me a complete list of all ID-numbers of the database. In order to get the specific information about each ID-number (article) a separate command is needed:
api.dabas.com/DABASService/V2/article/gtin/0?????????????/XML?apikey=2ad1a988-bd2c-4aa7-afa9-048bfa592229[/url]
Where the ? should be replaces with the ID-number of the specific product, for example 7318690055125
My question, is it possible, and if yes, how do automate the search of each product in my excel (Guessing that it has to be done in Power Query).
Greatful for some help!
Bookmarks