Pipeline error: Remote API returned authentication error -- Processed|Added|Updated|Unchanged
Hello fellow Quickbasers! I'm working with a scheduled pipeline and the bulk record sets steps. The PL searches the Sites table in App A and send two fields' values to two fields in a Sites table in App B. Both of these tables are connected tables and share the Record ID#2 value (which is also both of their key fields).
The Pipeline searches and finds the records in App A and then adds the bulk upsert rows in App B (this step should always be an update because of the merge key). At the Commit Upsert step, the Pipeline returns the error below with no further info. Two questions - Has anyone seen this? Does anyone have experience using a non built-in record ID field as the merge key?
Thanks!
Error:
Remote API returned authentication error -- Processed: 0 - Added: 0 - Updated: 0 - Unchanged: 0
PL Steps:
A: Prepare bulk upsert
B: Search Records
C: (start Loop) Add a Bulk Upsert Row (end Loop)
D: Commit Upsert
------------------------------
Raymond Sakar
------------------------------