Designing and Running Pipelines

How to split column values into new row

Hi Guys , I have below given json as input and i wanted to spilt it into difference rows based on multi valued columns . Input: “Cost_Center_Hierarchies”: [ { “Fucntional_Lvl4”: “CC6140”, “F_Lvl_4_Descr”: “Corporate - G&A” }, { “Fucntional_Lvl4”: “S...

How to create a file only with the header?

If no data from the sql execute ,then i want to create an empty csv file with column headers. The columns return from the database is not fixed.

Change OBJECT to ARRAY using Mapper

Using Mapper, we can change the Object in to array. In the below pipeline , data is generated using csv generator in plain text. Pipeline CSV generator configurations Changing the name from object to list. $Name instanceof Array?$Name :[$Name] Her...

Creating one more field in list of objects by using the fields in same objects

Hi Team, I have the below input data : [ { ID:123 “Name”:“Tony”, “Age”:24 }, { ID:124 “Name”:“Sam”, “Age”:36 }, { ID:125 “Name”:“Glenn”, “Age”:58 }] I need to add one more field ‘halfAge’ to the above and output data should be like below: [ { ID:123 ...

Task running ServiceNow Query snap - intermittent errors

When running a task with a ServiceNow Query snap against the incident table, in the error message: An error occurred while fetching the records (status code: 400). This related to the incident records or possibly a lost connection to ServiceNow.? I...

Ultra pipeline caching issue - SAP execute snap

Hello, Did anyone ever had caching issue with Ultra pipeline. I have ultra pipeline calling SAP BAPI using SAP execute snap. While executing the pipeline we are facing caching issue, where the response object of call 1 being returned for call 2. Than...

Issue with SQL connection with groundplex running as service

Dear community and expert We have the following scenario: Snaplogic connects to a Store procedure provided by MSQL. The authentication method used by the MSQL server is “Windows authentication”. We have a groundplex running at a Windows based VMware ...

Get all paginated query results

Hi All, I have a scenario that I am hoping someone here can help with… I need to iterate through paginated results which I know is easily done when using a REST GET call. However in my case I have to use a REST POST call. Essentially I query records ...

SnapLogic - Integration Nation

Forum Posts

How to split column values into new row

How to create a file only with the header?

Change OBJECT to ARRAY using Mapper

Creating one more field in list of objects by using the fields in same objects

Task running ServiceNow Query snap - intermittent errors

Ultra pipeline caching issue - SAP execute snap

Issue with SQL connection with groundplex running as service

Get all paginated query results

Trim and convert string into Date

How to output the SQL statement that was executed ...

How to identify if there are no files in the sourc...

Decode column name that has @ as a prefix

Cannot call parameter in the error pipeline

Formatting CSV data for XML output

Get MIN (oldest) or MAX (most recent) date from ar...

Line Break in Mapper

how to filter out spaces

Expression to extract values in nested JSON object...