Forum Discussion

bubba's avatar
bubba
New Contributor
4 years ago

Questions on using the SQL Server – Merge snap, where is WHEN MATCHED logic?

Hello, I’m a new user to Snaplogic, so go easy. 🙂 My question is on using the “SQL Server – Merge” snap: I’ve created a pipeline to import from a sftp csv-formatted source to merge (update or in...
koryknick's avatar
koryknick
Employee
4 years ago
Copy LinkReport

You might be able to get around it by using the following expression in a mapper before trying to process the $messages value:

sl.ensureArray($messages)

This way, if it is a single object, it will be a single-entry array. If it is already an arrary, it simply passes through.

  • bubba's avatar
    bubba
    New Contributor
    4 years ago
    Copy LinkReport

    Much thanks for your feedback. I’m still testing but it’s now working as expected as far as I can see.