I Using saleforce read snap to read data and write to s3 in parquet format but getting error due to 'picklist' data type which is not compatible to parquet. How to handle such datat types problem
Hi I need to form multiple records from one row based on date criteria, and the criteria are that when start date and end date have a difference of more than 1 year, it should have multiple rows for each year date as mentioned below: Input : ID Star...
Hi All,I am new to snaplogic.I've got this json output from Google Directory where the phone and fax number has field as value.I've got two fields in DB to get both the values of phone and fax. "phones":[{"value":"08 8344 1867""type":"work"}{"value"...
The zip file reader snap wont read my zip file with many files in it. Is there a limitation that you can only unzip a file with one file in it?
Pipeline sample that grabs per diem rate data from State Department website and imports it into Workday Rate Tables. It gets a little complex as far as the data mapping and filters, but cuts down on tedious manual maintenance of these tables. We run ...
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, I have a requirement where multiple instances of the same triggered task has to be run concurrently. I have a pipeline Load_control.pip that takes several inputs and based on different inputs, it performs different operations. A triggered ...
Hello Experts, I have input coming in as below:[{"soap:Body": {"@xmlns:soap": "http://www.w3.org/2003/05/soap-envelope","ns1:searchResponse": {"@xmlns:ns1": "http://siemens.com/agilews","recordmap": {"record": [{"field": [{"key": "T_FILE_DAT.FILE_TYP...
