Designing and Running Pipelines

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

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)

Replace "@" and "#" while converting XML to JSON

Hi All, I am converting XML file to JSON file using XML parser snap and JSON formatter. When I’m converting, prefix “@” is getting added to all the attributes. For example:- In XML → “ProviderPaxRef”: “String” In Converted JSON → “@ProviderPaxRef”: “...

Resolved! Select column based on column availability

Hi, I am reading multiple json files from source. where column names and column type are varying from file to file. For example: In one file, column name is coming as an array and in another file it is coming without array. But for my use case I don’...

SnapLogic - Integration Nation

Forum Posts

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

Set up error pipeline

Replace "@" and "#" while converting XML to JSON

Resolved! Select column based on column availability

split target csv file into more smaller CSV's

How can I edit/update my community posts?

Http Client Snap vs REST Post snap

Parsing CSV file

Data Validator Pattern error

Deleting multiple files at once from SFTP folder

SQS -pipeline stalling

Best Approach for Handling CSV Import with Truncat...

Fetch dashboard/monitor details via a pipeline

mapValues returns null when adding certain conditi...