I am reading a CSV/XLSX file (could be an sql table as well) with the follwing structure (file attached below as well):BranchYearTypeParentNumberCurrentNumberStructureLevelLanguage1Language1_ValueLanguage2Language2_ValueCreationDateLastUpdate12342024...
I have a couple situations where there are lists of values that will need to be referenced and those lists will change in different runs of the pipelines. Since they will change, updating mappers or conditionals doesn't seem ideal, so am thinking tha...
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....
Hi there, has someone implemented ISO 20022 compliant pipelines in SnapLogic before? Please share your experiences. Any other reference is appreciated. en.wikipedia.org ISO 20022 ISO 20022 is an ISO standard for electronic da...
I am trying to paginate using a POST HTTP CLIENT Snap. I don't know how to accomplish this with the information provided in the data returned. I am extracting data from HubSpot using the 'search' endpoint (https://api.hubapi.com/crm/v3/objects/cont...
Please I need some help to formulate this expression an expression. Essentially, is it possible for these three steps to be all done in one line? Thanks.trim($Clicks)trim($Clicks.replaceAll('-',''))trim(output of step 2)
Hello Experts,I have a JSON input looks like this:[{"id": "0000000","type": "DUMMY_Payload","userId": "ABCD1234"},{"id": "1111111","type": "DUMMY_Payload_1","userId": "QWER5678"},{"id": "2222222","type": "DUMMY_Payload_2","userId": "ABCD1234"}]The as...
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...
