travis_pendleto
New Contributor II
Joined 7 years ago
User Profile
User Widgets
Contributions
After using a JSON splitter and a filter, how do you put the object/array back together?
Hi, we needed to filter on a JSON input. We managed to get that working by using a JSON splitter on the element and then piping that to a filter snap. Our issue is now the input that looked like this: "allLocations": { "location": [ { "addressInternalid": 2631363, "isDelete": false, "internalSupplierid": 3423589, "acctGrpid": "RT", "address1": "5309 GREENWAY", "address2": "5301 REDWAY", "address3": "5504 BLUEWAY", "poBox": "0912KHJWD", "country": "USA", "state": "US-TX", "city": "FREE", "zip": "78211", "phone": "2229808888", "phoneExtn": "091", "fax": "747", "faxExtn": "737" }, { "addressInternalid": 2631367, "isDelete": false, "internalSupplierid": 3423589, "acctGrpid": "RT", "address1": "11305 4 PTS DR", "address2": "BLDG 2,#100", "country": "USA", "state": "US-TX", "city": "AUSTIN", "zip": "78726", "phone": "5126648805", "phoneExtn": "123", "fax": "123", "faxExtn": "134" }, { "addressInternalid": 2631368, "isDelete": false, "internalSupplierid": 3423589, "acctGrpid": "RT", "address1": "REMIT 11305 4 PTS DR", "address2": "BLDG 3", "country": "USA", "state": "US-TX", "city": "AUSTIN", "zip": "78725", "phone": "5126600000", "phoneExtn": "678", "fax": "678", "faxExtn": "678" } ] }, Looks like this: [ { "addressInternalid": 2631363, "isDelete": false, "internalSupplierid": 3423589, "acctGrpid": "RT", "address1": "5309 GREENWAY", "address2": "5301 REDWAY", "address3": "5504 BLUEWAY", "poBox": "0912KHJWD", "country": "USA", "state": "US-TX", "city": "FREE", "zip": "78211", "phone": "2229808888", "phoneExtn": "091", "fax": "747", "faxExtn": "737", "fullCompanyName": "SUPPLIER MARCH 3 dba TEXT", "requestId": 5272423, "id": "3423589", "facilityCode": "0001", "systemCode": "1", "supplierType": "Operational", "status": "ACTIVE" }, { "addressInternalid": 2631367, "isDelete": false, "internalSupplierid": 3423589, "acctGrpid": "RT", "address1": "11305 4 PTS DR", "address2": "BLDG 2,#100", "country": "USA", "state": "US-TX", "city": "AUSTIN", "zip": "78726", "phone": "5126648805", "phoneExtn": "123", "fax": "123", "faxExtn": "134", "fullCompanyName": "SUPPLIER MARCH 3 dba TEXT", "requestId": 5272423, "id": "3423589", "facilityCode": "0001", "systemCode": "1", "supplierType": "Operational", "status": "ACTIVE" }, { "addressInternalid": 2631368, "isDelete": false, "internalSupplierid": 3423589, "acctGrpid": "RT", "address1": "REMIT 11305 4 PTS DR", "address2": "BLDG 3", "country": "USA", "state": "US-TX", "city": "AUSTIN", "zip": "78725", "phone": "5126600000", "phoneExtn": "678", "fax": "678", "faxExtn": "678", "fullCompanyName": "SUPPLIER MARCH 3 dba TEXT", "requestId": 5272423, "id": "3423589", "facilityCode": "0001", "systemCode": "1", "supplierType": "Operational", "status": "ACTIVE" } ] How do I get it back into an object so I can map it correctly? As you can see in the below image, all of the location fields are coming in as strings with no hierarchy, not the array they were originally. Any tips would be appreciated!3.4KViews0likes2CommentsIngesting SalesForce Data
Hi I’m attempting to connect to a SalesForce instance using a SOQL snap, read all the table names, then use a pipeline execution snap to trigger a child pipeline that dynamically looks up all the field names for each table name it is fed, then pulls all the data for that table with another SOQL snap and pipes it to AWS S3. I have got parts of it working but sometimes the queries are too long and error out with SalesForce. Does anyone have a template or example of how to do this besides manually setting up a pipeline for every table?Solved3.6KViews0likes2CommentsConverting Array to Comma Separated String
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