Well that was an incredibly helpful response. It would difficult to enumerate all the things I was doing wrong. I have managed to get past that Authentication issue and generate a CSV response.
So my real purpose of this was to simulate an external API call to another non QuickBase system which would return a CSV file back. I am anticipating that need from my clients as a common response format from external systems is CSV.
Separately, I was also successful with the new Bulk Record functionality QuickBase which allow a step to create a Bulk Record "Upsert" (I had to google that word - it means to update or insert if not there). Then you add rows to the Bulk Record Upsert and then when done adding rows you "Commit" the Bulk Record Upsert and it will update or add new records.
So my next goal is to coax the returned CSV table into a Bulk Record Upsert.
My problem is that I do not know how to convert or iterate though the returned CSV data from the API_GenResultsTable. Strangely, when i change the API call to respond in format Application/json as opposed to Application/xml my Pipeline once again failed to Authorize. I was trying that because I saw that there was a Channel for JSON Responses that might be useful.
Any ideas out there how to convert a CSV response from a API call into a Bulk Record Upsert?
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.commark.shnier@gmail.com
------------------------------
Qrew Legend
