kachanta
New Contributor
Joined 4 years ago
User Profile
User Widgets
Contributions
Filter in the array
Hello Community, I have been trying hard to build a logic urgently. I’m requesting SnapLogic expression language experts to assist here. I have the input data like below and need to get the phone “number” filed validating 3 conditions. Type should be ‘Mobile’ in array “phone” type should be == ‘Voice’ inside the array “utilizationMeanings” endDate field should be null which is inside another array “dates” inside “utilizationMeanings” To detail: $ phones[ < find type = Mobile >].utilizationMeanings[ < find type= voice >].dates[< find endDate ==null>].number { “phone”: [ { “number”: “123456789”, “type”: “Mobile”, “utilizationMeanings”: [ { “type”: “Voice”, “dates”: [ {“startDate”: “2023-05-31T12:08:47.503Z”,“endDate”: null } ] }, { “type”: “Text”, “dates”: [ {“startDate”: “2023-05-30T00:00:00”, “endDate”: null } ] } ] } ] }Salesforce to Redshift
Hello Community, We are planning to implement a solution loading data from SFDC to Redshift, I searched for a pattern and found the following blog post helps very much. Unfortunately, we searched in the patterns but didn’t find the relevant one. We are now looking for the pipelines. Could someone help here please guide or share some info? Salesforce data has to be ingested into Redshift. SnapLogic – 9 Jul 19 Accelerating the integration of Salesforce data and Amazon Redshift The integration of Salesforce data with disparate SaaS applications, databases, and data warehouses is complex work. SnapLogic simplifies it with drag-and-drop integration. Thank you.4.4KViews0likes5Comments