Forum Discussion

Roger667's avatar
Roger667
New Contributor III
2 years ago
Solved

Passing Pipeline Parameters in Salesforce Soql Snap

When i am passing pipeline parameters 'time_column' and 'object_name' i am getting Error. Same with Salesforce read Snap    
  • j_angelevski's avatar
    j_angelevski
    3 years ago

    Hi Manzoor ,

    You can use the following expression to replace the NULL values with blank in the entity object, assuming it is a flat object.

    $entity.mapValues(val => val == null ? "" : val)

    This will simply iterate over each value in the entity object, and check if the value is null, if it is, it will return an empty string otherwise it will return the original value.

manichandana_ch's avatar
manichandana_ch
New Contributor III
2 years ago
Copy LinkReport

Hi Roger,

Please click and highlight the equals sign below 'SOQL Query'* in order to use the pipeline parameters in SOQL query. We need to make sure we enable the '=' to use expression language. Also please remove semicolon at the end or add it within quotes. (_object_name+';')

Thanks !