Getting the Most Out of the SnapLogic Platform

State Department Per Diem Rates to Workday Import Expense Rate Table

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 ...

jsonpath in expression library

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($,...

Postgres to parquet writer

I am trying to write data from postgres to parquet. The source has numeric data type which has can values as int, decimal or float. I have mapped numeric type to decimal in parquet but the issue is that it converts int values to decimal as well. ex 1...

Filtering out an Array

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...

Resolved! Unable to write salesforce data to s3 in parquet format

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

Resolved! Add fields dynamically in Encrypt field snap

Hi Team,The community is amazing and very helpful. Kudos to everyone behind it.I'm working on encrypting certain fields(PII) coming from SFDC sources and using encrypt field snap for the same. For that I'm having to add the fields manually in the sna...

Resolved! Coupa API GET

hi there, I need to call Coupa API to do a GET but their API only lets me get 50 records at a time, but they have over 7000 records that I need to pull. how can I increament my url https://instance.coupahost.com/api/invoices?offset=50&exported=false...

Pagination for Coupa API GET

Hello,I need to extract all records from several Coupa tables using Coupa API. However Coupa only allows to extract 50 records at a time (Coupa documentation). I tried implementing the solution in this thread (link) for invoices and suppliers table b...