SnapLogic - Integration Nation

sravan · 11-09-2023

Hi ,I have a requirement to join the array1 with array2 in the same document and fetch one column from array 2 into array1 if condition matches. I can do it by splitting the arrays and join them back again. I would like to to know if i can do it in m...

sravan · 11-07-2023

Hi,I have a requirement where we need to read 50 tables from oracle and put the data to postgres. there is no transformation logic in between . But issue is while loading to target the column names are slightly changing. for an instance , src_table1{...

sravan · 06-23-2023

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 · 05-31-2023

I have a requirement where I need to convert an array into new array . Below is the example . INPUT: { “cover”: [ { “needCode”: “abc”, “needKindName”: “abc xyz”, “autoBoostCoverAmount”: { “amount”: 25, “currencyCode”: “XAF” }, “coverAmount”: { “amou...

sravan · 05-15-2023

Hi We have a requirement where, If we do an api call , we get response something like below { records_remaining : “200”, records_processed: “100”, failed: “0” }, “entity”: [ "rec1: “abc”, “rec2”:“xyz” ] Pagination does not support by Api . we need to...

sravan · 11-09-2023

Thank you @koryknick that works.

sravan · 06-27-2023

Thank you! Some How it is not fetching the last page data. I had to change Has next url to something like below: $entity.rows.length==100. so that it loops till the rows are 100. if rows array is not 100, which means there is no further data. Thank...

sravan · 06-01-2023

actually this works only if we have covers. I got into another problem now. I am pasting INPUT and OUTPUT here. could you please on how we can transform this. I used json generator to transform but no luck. @AleksandarAngelevski INPUT: { “summary”: {...

sravan · 05-31-2023

Hi @AleksandarAngelevski Both Works.The first method is kind of hard coded one. We need to lookup on coveraount. it yes we need to proceed else create a empty array. Second one is working fine for me. I appreciate your help in this regards

sravan · 05-16-2023

Thanks @bojanvelevski you are a Savior. It works!

SnapLogic - Integration Nation

User Statistics

Re: Changing the key names dynamically

Join array of Objects

Changing the key names dynamically

Re: Smartsheet rest api pagination

Smartsheet rest api pagination

User Activity

Join array of Objects

Changing the key names dynamically

Smartsheet rest api pagination

Transform Array to New array

Looping through Api call

Re: Changing the key names dynamically

Re: Smartsheet rest api pagination

Re: Transform Array to New array

Re: Transform Array to New array

Re: Looping through Api call