Hello community,
In the company I work in we use Alteryx and have a Macro to retrieve data from the Harvest App (https://www.getharvest.com/) (SEE ATTACHED for the Macro).
After analysis we found and issue where values are shifting to the next column when we retrieve the data from Harvest App (SEE SCREENSHOT1). I’m sure the problem resides within the Macro, but I haven’t been able to solve it.
Background info: using Postman to retrieve data from the Harvest App API we found the data comes as text and it only permits a limit of 100 records per page to be retrieved. At the bottom of the data retrieved there is an explanation on how to see the other pages. (SEE SCREENSHOT2)
Our Macro retrieves all the pages and performs a “Text to Columns” and a “Cross Tab” to output a spreadsheet of the data but on the “page breaks” the data shifts one column over (SEE SCREENSHOT1) we are using the "R" Output not the "U" Output. I don't understand how the Macro is adding the next pages to the "R" Output.
We need to retrieve multiple pages of data out of Harvest App and this error is causing inconsistencies in the data we need to move from Alteryx to other internal systems.
Do you know how to help us with this issue or if there’s a better way to retrieve the data from Harvest App as a spreadsheet
