Forum Discussion

giselle_rayner's avatar
giselle_rayner
New Contributor
8 years ago

Request Body in Rest API Pipeline

I am new to APIs and trying to develop a simple pipeline. I am authenticating and then searching by first name and last name and expecting the call to return the IDs associated with the person (in ...
nchrk's avatar
nchrk
New Contributor II
3 years ago

expression failing when input string contains blanks or null values using this expression “JsonStr.toString().replaceAll(‘\n’,‘’).replaceAll(’ ‘,’')”

any suggestions how to resolve this when we receive blank/null values?

Abhishek_Soni37's avatar
Abhishek_Soni37
Contributor
3 years ago

Can you share example of input data(with blank/ null values)

  • nchrk's avatar
    nchrk
    New Contributor II
    3 years ago
    1. input value JsonStr := [\n “AC”\n]
      expected output := [“AC”]
    2. input value JsonStr := [\n “AC”,\n “BD”,\n “DE” \n]
      expected output := [“AC”,“BD”,“DE”]
    3. input value JsonStr := null
      expected output := null
    • Abhishek_Soni37's avatar
      Abhishek_Soni37
      Contributor
      3 years ago

      You can use this expression: $JsonStr != null && $JsonStr != “” ? $JsonStr .replaceAll(“\n”,“”) : $JsonStr

      Explanation: This will first check if the JsonStr is null or empty, if it’s not then it’ll do the replacing else it’ll just put input jsonStr as output. In your case where JsonStr is null it’ll show output null

      • nchrk's avatar
        nchrk
        New Contributor II
        3 years ago

        Thanks Soni for your response. But i’m getting error when this property is not available in input schema object in mapper.
        Error :- $JsonStr is not defined

        how do we check the property exists or not. if exists, replace the values
        $.get(‘JsonStr) != null && $.get(‘JsonStr) =“” ? $.get(‘JsonStr).toString().replaceAll(’\n’,’'):$.get('JsonStr)