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

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