Forum Discussion

karthik_dhina's avatar
karthik_dhina
New Contributor
4 years ago

Mapper - change value in target path based on condition

I have the below req. i want to update the value of a column only if it’s null else leave as it is. ex: raw_table.date_joined will be populated only if it’s null, if it’s already have a value lea...
jshanaiah's avatar
jshanaiah
New Contributor II
7 years ago
Copy LinkReport

Thanks @tlikarish

yes , I need to pass the authorization token which will be used to call another service.
I read document. I would require to send it in JSON body in a POST request.

Api I am trying to build is GET . @tlikarish How to achieve it for GET request?

  • darshthakkar's avatar
    darshthakkar
    Valued Contributor
    4 years ago
    Copy LinkReport

    @karthik_dhina: The solution has been provided by @bojanvelevski - trust me it works. If at all you do not want to use a mapper then you can always leverage some snaps like filter and router for the same but you’ll have to use a mapper after the results are filtered and assign the default value.

    Alternatively, you can also use Conditional snap to achieve similar use cases.