Designing and Running Pipelines

Resolved! Fetch data whose date is less than 10hrs from the existing date!

Hi Team, I’m trying to achieve a filter condition but haven’t found any luck so far. My data has a field as Last_Updated which has date stored in the format 2022-06-23 03:54:45 I want to consider only those records whose date is less than 10 hours th...

Resolved! Get apim (APIs in SnapLogic) metadata

Hello, I’m using the snaplogic Read and SnapLogic list snap to get all the metadata of snaplogic (accounts, pipelines and tasks) but know I want to get the metadata also from the apim (accounts, tasks and pipelines from the APIs). For know I only cou...

Reading JSON Format

Hi, How I can use an expression to read the below in a mapper to get individual values true or false? I am using as - $DocumentId.startsWith(“EBSPERSON_”) [ { "Content_ID": "EBSPERSON_547229" } { "Content_ID": "EBSPERSONAD_547229" } { "Cont...

Mapper: map to target path only if input path is not null

I’m building a pipeline to update some existing data, and I have a Mapper mapping from source input fields to destination target fields. The input data is incomplete – i.e., there are a lot of fields that can be null on any given input document. Fo...

SQL Insert from JSON change type and only type

Hi All, I have a Pipeline that takes data from a Rest API and converts it to a SQL database. This is all working and we are able to create the table without having to define the Schema in a mapper (we have hundreds of tables with thousands of fields...

Read SOAP Execute Response content which is in CSV and write into a DB table

I am trying to read the SOAP CSV response in Binary form and write each record into a table. The SOAP response in encoded in Binary for as “content” in one big “string” data type I want to write them into a table by breaking that string into multiple...

Facilitate SAP RFC Calls between two SAP Systems

Dear Community, we have a existing Use-Case where we want to facilitate RFC Calls between two of our SAP Systems. SAP System 1 → SnapLogic → SAP System 2 The arrows simulate RFC Calls. For the connection between SAP System 1 and SnapLogic we use the ...

Resolved! Passing mapper variable for WSDL URL in SOAP Execute

Hello, I am trying to send the WSDL URL into SOAP Execute by initializing in a mapper and then send that variable to SOAP Execute WSDL URL as mentioned below. But I am encountering an error. Is it possible to send variable to WSDL URL in Soap Execute...

SnapLogic - Integration Nation

Forum Posts

Resolved! Fetch data whose date is less than 10hrs from the existing date!

Resolved! Get apim (APIs in SnapLogic) metadata

Reading JSON Format

Mapper: map to target path only if input path is not null

SQL Insert from JSON change type and only type

Read SOAP Execute Response content which is in CSV and write into a DB table

Facilitate SAP RFC Calls between two SAP Systems

Resolved! Passing mapper variable for WSDL URL in SOAP Execute

Fetch dashboard/monitor details via a pipeline

mapValues returns null when adding certain conditi...

What account should be used for API with query par...

How to dynamically update an account?

Execute each child pipeline multiple times

Routing files from S3

Clean duplicated lines in CSV datasource

How to get all values of a key from objects in a l...

The "Pipeline execute" is changing data types?

Remove XML duplicate key from JSON list in XML for...