Designing and Running Pipelines
Discuss how to use the SnapLogic platform.
cancel
Showing results for 
Search instead for 
Did you mean: 

Forum Posts

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

mohit3 by New Contributor
  • 1006 Views
  • 1 replies
  • 3 kudos

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

manohar by Contributor
  • 1755 Views
  • 2 replies
  • 2 kudos

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

vaidyarm by Contributor
  • 1780 Views
  • 2 replies
  • 5 kudos

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

MEsponda by New Contributor
  • 1721 Views
  • 1 replies
  • 0 kudos

Smartsheet rest api pagination

Hi , We are integrating smartsheet rest api’s in snaplogic. We get only totalrecordscount in the response. there is no other things comes up in response. I need to apply pagination . In paramters i can use page and pageSize . Page is something which...

sravan by New Contributor II
  • 2248 Views
  • 2 replies
  • 1 kudos