โ02-05-2020 09:14 AM
I have JSON output from a Salesforce SOQL snap, in the format
[
{
โQualifiedApiNameโ: โAccelerator_Pack__cโ
},
{
โQualifiedApiNameโ: โAccess_Certifications__cโ
},
{
โQualifiedApiNameโ: โAccess_Requests__cโ
},
{
โQualifiedApiNameโ: โAccount_Cleansed__cโ
},
{
โQualifiedApiNameโ: โAccount_Contract_Status__cโ
}
]
I am trying to convert it to a string in the format " ```
Accelerator_Pack__c, Access_Certifications__c, Access_Requests__c, Account_Cleansed__c, Account_Contract_Status__" so I can use it dynamically in the SELECT clause of another query.
I thought the .toString function would do this, but as you can see in the image of my mapper snap, itโs not making any change to the structure.
Any help would be appreciated!
Solved! Go to Solution.
โ02-06-2020 06:07 AM
I bet that would work too. I got a solution from someone on Stack, I piped the QualifiedApiName into a Concat snap, then replaced the โ|โ with โ,โ in a mapper snap.
โ02-06-2020 05:17 AM
I believe you want to use .join()
โ02-06-2020 06:07 AM
I bet that would work too. I got a solution from someone on Stack, I piped the QualifiedApiName into a Concat snap, then replaced the โ|โ with โ,โ in a mapper snap.