Power Query Rest API and implement a logic when data pulling from eCommerce store

[arifulice]

I have a excel sheet with power query connetions to a rest api of my ecommerce store. Now i want to use this as a template in the future and therefore i want to lock the excel via another power query that checks a server for a license code. i already have the rest api and everything.
The only thing that needs to be done is the following:

There is a cell where you can enter the license code. if the license code go entered, the power query should check with this code against the rest api, if the code is valid. if the response is "ok", the excel should load all other power queries. If the response is anything else, the excel should stop and trow and error.

Do you knwo what i mean?
Here is a example url. Only if "Success"="True", the excel should work...

[v-yulgu-msft]

Hi @arifulice,

Whether Excel supports such a feature that users can enter a license which is passed to Power Query to check of it is valid, you should post thread on Excel forum. And how to achieve this requirement that create a M function to check the license, you'd better post thread on Power Query forum to get more professional suggestion.

Regards,

Yuliana Gu