Designing and Running Pipelines

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

Rest DELETE without passing body

Hi! I have a pipeline that gets a list of IDs from a Rest GET. So i have these splitted JSONs with one ID in each. I need to make a Rest DELETE for each of these ids, but the ID must go on the URL and the body must be empty. I left the HTTP Entity fi...

SnapLogic - Integration Nation

Forum Posts

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

Rest DELETE without passing body

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

Generating individual files based on 'n' records f...

Convert array with objects into object with key/va...

Converting a string to JSON doesn't work

Rest Post for Multipart form type content type wit...