Hi,I first do an SQL Server - Execute and get this weird {_snaptype_localdatetime: "..."} for the CreationDate and LastUpdate fields. Then, using a Mapper snap I do toString() to just get the date fields in string form. Then, I do a Group By on some ...
Hi,I have an expressions library file which creates a JSON object like this: ... .map((elem, idx, arr) => { "fieldA": elem.fieldA, "fieldB": [ { "fieldC1": elem.fieldC1, "fieldC2": elem....
Hello,I'm looking for help with an expression to extract values in nested JSON objects.I've figured out how to extract any elements in "field" array where "lastModified" is after "lastExtractionDate".But problem is that I also need to extract the val...
Hello SnapLogic Community,I'm a Salesforce administrator working with SnapLogic to process data from an Oracle server. My pipeline calls a function that returns a multi-level JSON file. I need to extract data from this JSON and insert it into various...
Hello all! Hoping for some helpful suggestions or insight regarding an issue we're facing with the new HTTP Client snap.We're sending a POST request with a JSON body. Within the body are street addresses, and some addresses contain diacritical marks/...
I would like to use a jsonpath in an expression library, but I am unsure of the syntax with parameters.custfield is a json array of custom field data and fieldname is a stringThis is what I attempted:{customField: (custfield,fieldname) => jsonPath($,...
Hello Experts,I have below Object input containing string values. Can someone please provide expression to get rid of duplicate values?[ { "ack": { "QueueURL": "https://www.google.com", "ReceiptHandle": "12345678", "content": "ABCDEFG" } }, { "ack": ...
Hello Experts,Below is the Input schema for my data:My objective is to extract value of ntgr where value of key = 'xyz'Thanks in Advance
