Turning Array Into String in SnapLogic

Question

I have the output of a SalesForce SOQL snap that is a JSON in this format.

[
  {
    "QualifiedApiName": "Accelerator_Pack__c"
  },
  {
    "QualifiedApiName": "Access_Certifications__c"
  },
  {
    "QualifiedApiName": "Access_Requests__c"
  },
  {
    "QualifiedApiName": "Account_Cleansed__c"
  },
  {
    "QualifiedApiName": "Account_Contract_Status__c"
  }
]

I am attempting to take those values and turn them into a string with the values separated by commas, like this, so that I can use that in the SELECT clause of another query.

Accelerator_Pack__c, Access_Certifications__c, Access_Requests__c, Account_Cleansed__c, Account_Contract_Status__c

From the documentation, my understanding was that .toString() would convert the array into a comma-separated string, but as shown in the attached image, it isn't doing anything. Does anyone have experience with this?

You need to aggregate the documents. Otherwise, you won't be able to process all the elements in the array at once... — Bilesh Ganguly, Feb 05 '20 at 19:14

score 2 · Accepted Answer · answered Feb 05 '20 at 19:30

You need to aggregate the incoming documents.

Use the Aggregate snap with the function CONCAT. This will give you a | delimited concatenated string as the output like as follows.

Accelerator_Pack__c|Access_Certifications__c|Access_Requests__c|Account_Cleansed__c|Account_Contract_Status__c

You can then replace the | with , like $concatenated_fields.split('|').join(',') or $concatenated_fields.replace(/\|/g, ',').

Following is a detailed explanation of the configuration.

Sample Pipeline:

Sample Input:

I set the sample JSON you provided in a JSON Generator for testing.

Aggregation:

Result of Aggregation:

You get a | delimited concatenated string.

Mapper Expression:

Output:

Both expressions give the same result.

score 0 · Answer 2 · answered Nov 04 '20 at 10:16

You can also use the array functions directly to achieve this. see the below pipeline that can be used to concat the values:

I have used the JSONGenerator for taking your sample data as input. Then I have used the GroupByN snap with '0' as the group size to formulate the array.

Finally in the mapper you can use the below expression to concat:

jsonPath($, "$arrayAccom[*].QualifiedApiName").join(",")

Turning Array Into String in SnapLogic

2 Answers2