Designing and Running Pipelines

JSON Splitter to REST Call capture all response bodies

I have a pipeline that takes an Array of JSON as input. We then feed it to a JSON Splitter that then goes into a REST POST to some endpoint. I see that all of the REST calls go through in the Ultra task, however only the first response body from the ...

REST GET to SharePoint

I’m creating a Pipeline to pull data from a SharePoint list and having an issue using the REST GET with my OATH2 account I created. I am getting a 403 error Access Denied. I did walk through the setup of the account and did the authorize and did get ...

Netsuite all objects

The requirement is to retrieve all objects/tables in netsuite and then get whole data from each objects individually. How it can be achieved in netsuite? Please help.

Need help to generate json format as per maximo target requirement

I have an input in below format: which i need to transform into a json structure like below in order to load the asset to maximo, where highlighted ones are part of column list in input file and its corresponding value is to be saved in ALNVALUE col...

Transpose array row to columns

Hi Team, I need to convert the values present in an array with comma separated into different columns. Not sure how to use pivot snap for this logic, can someone help me with the same?

Resolved! How to best combine/map values from separate inputs?

I’m trying to produce output containing Value and Item ID from separate files. I have two input files for this, with different naming for the fields For example, Transaction Name=TRANSACTION First Name=FNAME LastName=LNAME In addition, one file conta...

How to do 'Not equal' in Lookup conditions section of SQL Lookup snap

How can I do below query with SQL Server Lookup snap: SELECT * FROM table where status<>‘D’

Resolved! How to get Index of Array list along with the data

Hello, I am working on API’s and while pulling the data from API and storing in the DB. The API is returning data in Arrays and while using the splitter i am able to split the data of arrays and load into the DB. But my requirement is to also store t...

SnapLogic - Integration Nation

Forum Posts

JSON Splitter to REST Call capture all response bodies

REST GET to SharePoint

Netsuite all objects

Need help to generate json format as per maximo target requirement

Transpose array row to columns

Resolved! How to best combine/map values from separate inputs?

How to do 'Not equal' in Lookup conditions section of SQL Lookup snap

Resolved! How to get Index of Array list along with the data

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

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

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