โ03-22-2022 06:46 PM
Hello Out there, I've been trying to create a CSV file from a Custom Select Qurery Action in Big Query. I am using variables to create a List to repeat through and update a final list to dump into csv. I've used variables previously succesfully, but with using the Custom Sql for BQ, my initial list is not ever populated.
Any advice or help would be great.
Thank you.
โ03-22-2022 06:57 PM
Tracy - I believe step 6 should actually be FOR EACH item in...the list from step 2, not the variable list from step 3. Without seeing what's in step 9 - I assume you're using These_are_the_updates list as the Source
โ03-22-2022 09:07 PM
Thanks for the response Pam. I had tried that as well. What I am seeing is that due to the nature of the Big Query Response, the rows are not in a array. It looks like I may need to add a step to parse the response so I can use the data pills.
โ04-12-2023 06:02 AM
Did you tried in debug/trace option for each step if records are coming across within the Recipe ?