Thank you for your answer,
On blue mi answers over your questions:
Could you detail a bit more what you’re planning to do?
The api that I´m working with only deliver 50 lines per call, to move forward to the other call you need to replace an endpoint with data from the data that you receive on the first call, the number of calls depend on the lines until you get a 0 value on the column that has the information from the end point.
I already tried and worked manually.
But I need to know If I can schedule this process to run overnight and if I can export this data into a csv automatically.
On the next link the API description and the API field description:
Are you expecting the API that Postman queries to return the filtered CSV straight away or are you expecting it to return the whole CSV and then to do the filtering in Postman?
Any of these options could work, the best one is to be able to filter and then get the csv but if it’s not possible I will work with the entire CSV file. The reason why I’m interested in getting a CSV file is because is a lot easier to work with this files in Power Bi or Qlik.
how big of a CSV file are you talking about?
Maximum 6,000 lines in 10 columns, the maximum file size is around 1.5 MG
Any comments or ideas will be more than appreciated!!!