This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Accept
Reject
Preferences
FAQ
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results forย 
Search instead forย 
Did you mean:ย 

Mapping Single Record or Multiple Record

anilv
New Contributor II

โ€Ž09-22-2019 11:52 PM

Hi all,

When Designing Pipelines,we are getting response using the Get method,

  1. Sometimes we will get only one record in the response we need to use the different mapping,
  2. Sometimes we will get the multiple records in the response we need to use different mapping(because response getting is array).
    Canโ€™t we use only one mapping in above Condition,

Please help me on this,

Thanks,
Anil

0 Kudos
2 REPLIES 2

Supratim
Contributor III

โ€Ž09-23-2019 12:10 AM

@anilv
Use sl.ensureArray($response) and then use json splitter. It should work.

SpiroTaleski
Valued Contributor

โ€Ž09-23-2019 04:57 AM

Hi @anilv,

Best approach is to use sl.ensureArray() function and put the response from Get request as parameter of the function(ex: sl.ensureArray($response)). In this way you will ensure that the response from Get request will be always array. After that you can you JSON Splitter snap and split the array into separate JSON documents.

If you have any questions fell free to contact me.

Regards,
Spiro