Issue using mapValues and mapKeys functions in Mapper Snap

[snapation6713]

I have data from salesforce that contain fields with a suffix of '__c' and the dates are formatted in UTC. I want to format the incoming data using the mapValue and the mapKey functions to remove the suffix and make all fields lower case AND format the dates into US/Eastern timezone.

I cant get the code to do all that I want: I have the following configuration n my mapper with a $ as my target:

$.mapKeys((value, key)=>key.endsWith('__c')
  ? key.replace('__c','').toLowerCase()
  :key.toLowerCase())
    &&  
 $.mapValues((value, key) => key.toLowerCase().search("createddate") >=0 && value !=null
  ?  Date.parse(value).toLocaleDateTimeString({"timeZone":"US/Eastern"})
   :value) 

This logic formats the dates but not the columns If I reverse it the columns are formatted and not the dates. Same thing if I change the && to ||. How can I get both transformations? Please help!

[SpiroTaleski · Accepted solution]

@snapation6713 

Try with this expression: 

$.mapKeys((value, key)=>key.endsWith('__c')   ? key.replace('__c','').toLowerCase()   :key.toLowerCase()).mapValues((value, key) => key.toLowerCase().search("createddate") >=0 && value !=null  ?  Date.parse(value).toLocaleDateTimeString({"format":"yyyymmdd"})   :value) 

[SpiroTaleski · Accepted solution]

@snapation6713 

Try with this expression: 

$.mapKeys((value, key)=>key.endsWith('__c')   ? key.replace('__c','').toLowerCase()   :key.toLowerCase()).mapValues((value, key) => key.toLowerCase().search("createddate") >=0 && value !=null  ?  Date.parse(value).toLocaleDateTimeString({"format":"yyyymmdd"})   :value) 

[snapation6713 · Accepted solution]

Thank you so much!  It worked!

[snapation6713]

Thank you so much!!! It worked!