API load more than one URL and after refresh show empty

[daniel_007]

Hi there, I have a lot of issues with an API connection.

First, I must connect to the API with an URL type https://api/servicios/v1/publico/nn.json?fecha=02022014&ticket=AAEE, that give me 1000 rows per day.
Then, I must compare all the names with a manual list of names (Excel). If one of the names in the Excel list appears in the API data, mark that row.
If found 10 matches, for example, a new URL must be triggered with each of the 10 codes separately: https://api/servicios/v1/publico/nn.json?code=code1/10&ticket=AAEE.

The first time it's ok. But if I refresh the dashboard again, all the tables appears empty.

The queries I'm using are:

LiciData --> First URL to the API connection. Bring 1.000 rows

ExcelList

SearchCoincidence

PositiveCoincidence

CodestoSearch

Function --> Bring all 10 URL calls to the API

ReportTable

I know that I can't put all the Dashboard in here, but please ask me what do you want to know to clarify the problem and try to get the correct queries.

Thanks

[lbendlin]

What is your question?  Which application are you planning to use for communication with that API?

Keep in mind that Power BI is not a source data storage solution.