Designing and Running Pipelines

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

Resolved! Parsing the string as a csv

Hi, I want to parse my dataset which is coming out as a string. Here is the example of the dataset [“field_name1,field_name2,field_name3,field_name4,field_name5,field_name6,field_name7\nValue1,Value2,Value3,Value4,Value5,Value6,{Val7.1:val,Val7.2:val...

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

Set up error pipeline

I have configured error pipeline but the error is not passing into input view. Need help to configure this. Thanks error pipe_2020_08_27.slp (2.2 KB) rest api_2020_08_27.slp (2.7 KB)

SnapLogic - Integration Nation

Forum Posts

Netsuite all objects

Need help to generate json format as per maximo target requirement

Resolved! Parsing the string as a csv

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

Set up error pipeline

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