Forum Discussion
Thanks for the note. Specifically what I'm doing is creating a google doc template. The goal is to merge in the data to the template. I have done this already where I can map in single data fields (Example: Name, company, date, etc) but when there is a connected table the challenge has been getting a storing the data. The hope was not to have to create a loop to get and store the data and then map that to a field in the google doc template. I can look into the API_GenResultsTable since I used this when I used to use exact forms. If you have any other suggests that would be great.
------------------------------
Scott Talarico
------------------------------
For GenResultsTable you can provide a parameter in options for 'csv' that will return the query/report in raw CSV format if you can pass that into your merge.
The other option if you need an actual array is to query for the data from QB and just transform it using Jinja to create a collection that you can pass into your merge. You could do a loop in the Pipeline step itself where you're sending the merge and just build the actual collection on the fly. Same conceptual concept as Workato except you'd be building it in the actual step where you're sending it to Google instead of building it in advance and passing it along.
------------------------------
Chayce Duncan
------------------------------