Hello everyone,
I have the following workflow I’d like to show you, where I’m encountering a problem:
This involves extracting a number of records using SOQL from the Salesforce CRM. Then, it adds columns with some constants to each record. After that, it iterates through each record, transforming certain values based on a lookup value. Finally, all these records are put back into an array, which is then written to a pipe-delimited (.csv) text file and uploaded to an FTP folder.
The problem is that in the “Create CSV” module, I want to get the output array from the “Array Aggregator [22]” module. However, the result is an array in the form of [object Object]:
The strange thing is that in the input of this “CSV Aggregator” module, within the bundle, the array shows the correct values in the following way:
The output of the previous module, “Array Aggregator [22]”, has the expected result; therefore, this problem shouldn’t exist:
And when I open the CSV file, I see the same problem:
Additionally, I’m including the blueprint.json file for more detailed review to facilitate troubleshooting.
blueprintWeb2.json (37.0 KB)