Designing and Running Pipelines

Dynamic passing in REST API

Hi , I was trying to invoke the REST API dynamically . Let me share my requirement , I have on REST API in place which gives certain information of each country with respect to the country_id . Each country_id is unique , so instead of placing the co...

Getting issue in creating JSON

Need to convert the below source JSON to target JSON Source : “Header”: { “Customfield”: { “ABPER”:“202303”, “ABKRS”:“SL” } } Target : “Header”: { “Customfield”: { “fieldname” :“ABPER”, “fieldvalue” : “202303” }, { “fieldname” :“ABKRS”, “fieldvalue” ...

Resolved! How to check object exists in an array

I have an array eg { “groupBy”: { “rowKey”: “0141116963814” }, “group”: [ { “rowKey”: “0141116963814” }, { “rowKey”: “0141116963814” }, { “rowKey”: “0141116963814” } ] } Now I’m accessing each element of group in mapper and I require to have the nul...

Resolved! Help handling arrays with in arrays

Hi there, I am trying to handle arrays within arrays and getting error. can someone please take a look at the attached pipeline and point out what’s wrong? helpwithhandlingarray_2023_06_16.slp (7.8 KB) Thanks

Pipeline execute response validation when no data in child pipeline

I need to capture the response of child execution result in the parent pipeline execute , but when no dat is there in child, we dont have any response in parent and i need to validate this for inputrecords or generate input record for audit if no d...

How to Convert Timestamp from 1 min to 5 min

we have the number of rows divided by 1 min each “2023-04-01 12:00:00 UTC” “2023-04-01 12:01:00 UTC” “2023-04-01 12:02:00 UTC” “2023-04-01 12:03:00 UTC” “2023-04-01 12:04:00 UTC” “2023-04-01 12:05:00 UTC” “2023-04-01 12:06:00 UTC” “2023-04-01 12:07:...

Flattening JSON

Hello, I am struggling to flatten out some JSON. I looked at a bunch of the examples and did my best to figure it out but still having no luck. Below is what I am looking for. Current: [ { "items": { "item1": { "1": "i1_1", ...

How to write a CSV using HDFS Writer

Hello! I have a issue, When I try to write a csv using the HDFS Writer… the snap aborted So… the question is if someone know what is the limit size of the file that I can write using the HDFS Writer? Because the file that I want to write is about 10 ...

SnapLogic - Integration Nation

Forum Posts

Dynamic passing in REST API

Getting issue in creating JSON

Resolved! How to check object exists in an array

Resolved! Help handling arrays with in arrays

Pipeline execute response validation when no data in child pipeline

How to Convert Timestamp from 1 min to 5 min

Flattening JSON

How to write a CSV using HDFS Writer

Append input data vertically

Difference between 2 dates

Find unmatched data using join

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