Forum Discussion

nluu's avatar
nluu
New Contributor II
3 years ago

JSOn body for property with null value

Hi all, I’m having an issue while designing the mapping property with null value for my JSON object. For example I have a Mapper to map $input to $body with the expression like follow: {“my_id”: ...
expression_language
pipeline
bojanvelevski's avatar
bojanvelevski
Valued Contributor
3 years ago

Hi @nluu,

You can try the following expression:

$input.mapKeys((v,k)=> "my_"+k.toLowerCase())

I believe it should do the work.
Regards,

Bojan

nluu's avatar
nluu
New Contributor II
3 years ago

Hi @bojanvelevski,

thank you for your response. It actually a very good solution. But in my case, the name is not always in the format of “my_” + key. The name will depends on the naming I agreed with the Database team and the CRM team, so sometime it will be like “close_date”: $input.ProductEffectiveDate_c etc. But I’ll try to base on your suggestion to find out the solution. Thank you so much
Regards

  • alchemiz's avatar
    alchemiz
    Contributor III
    3 years ago

    Hope this helps 😀

    {“my_id”: “Id”, “my_name”: “Name”, “my_address”: “Address” }.mapValues((val,key)=> $input.get(val,{})).filter((val,key)=> (!(val instanceof Object)||!(val.isEmpty())))