I need to generate a PDF file with a list of:
Item A - Date - Address - Value A
Problem lies with the fact I need to merge 2 API Responses.
Endpoint A give me:
Item A - Date - Address.
Endpoint B gives me:
Item A - Date - Value A
Currently I use:
Endpoint A launches a workflow on a list and saves Dates and Addresses.
Then after 10 seconds another set of workflow starts and creates a list of items with value A and matches the address looking for the first earlier date than the one on second endpoint response..
Then I display all of them and print with SelectPDF and send on email.
In general this workflow generates a lot of WU, especially if we want to target a month.
Is there a better way to match data in bubble (line in Xano) where I can sort of match them in one action, where I refer to not items but a set of data (so I do not have to save all of this).
If I have a paginated response (as I get max 1000 records at once, and sometimes I need to launch it 3 times) - how should I add 2 JSONs if I were using something other than things?