AnsweredAssumed Answered

Batched input mapping only produces one row

Question asked by doug458967 on Sep 8, 2016
Latest reply on Sep 12, 2016 by 51662476

I'm doing a basic SFDC select and then upserting the data into a Postgres database. I've been running into some performance issues and have been trying to experiment with batching to speed things up. I followed the guide here:

How to use the Batch Results Option on SFDC Query Operations.

 

As expected, only a single list document (containing multiple 'rows') is returned from the initial query. I edited the XML profile to include the extra List element (as seen in the guide). But when I feed that list document into a map, only a single row comes out and gets written to Postgres. So, I guess the question is, how can I feed a single document with multiple records into a map and have that map spit out multiple mapped records? Right now, if 100,000 rows are returned from Salesforce, only one row gets written to Postgres. I need all 100,000 rows to be written.

 

Thanks for any input!

Doug

Outcomes