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

Help to parse Json data into csv

Updating Salesforce contact object and Account Loo...

Slicing Data from JSON

Connecting Confluent Kafka using OAuth

Hexadecimal to binary conversion

array.map if field1 meets criteria, I want field2

Filter Array data

How to create timestamps and out put them only usi...

Do JSON mapping in a single mapper

Problem with nested mappings