how to handle dollar sign $ in variable binding

[Lynn]

Hello Team,
In a REST connection. I defined some variables in ConnectionJSON and tried to use them in ImportAccountEntJSON.

httpParams contained multiple parameters, host, port and authMethod should be from ConnectionJSON via binding variables. There are also additional parameters.

when I included dollar sign $ as value (in my example, it is "$T") in any of the additional parameters, it will cause the variables binding not working.

value of host will become "${connection.ConnectionInfo.host}" instead of the value "host70.ca" from ConnectionJSON.

if I removed the value with dollar sign, variables binding worked.

Do I need to escape $? I tried \\$, but it did not worked.


Below is the details of ConnectionJSON and ImportAccountEntJSON


"ConnectionJSON": {
"authentications": {
"OSService": {
"authType": "oauth2",
"url": "https://hostname/api/TestConnection",
"httpParams": {
"password": "Snp@ssw0rd",
"grant_type": "password",
"scope": "useraccount",
"client_id": "3c774f2fb7e83110cdb30652042d0ba9",
"client_secret": "`$v9R3m7[O",
"username": "admin"

},
"ConnectionInfo": {
"host": "host70.ca",
"port": "443",
"authMethod": "password"
} ,
"httpHeaders": {
"Content-Type": "application/x-www-form-urlencoded" },
"authError": [
"InvalidAuthenticationToken" ],
"httpMethod": "POST",
"httpContentType": "application/x-www-form-urlencoded",
"errorPath": "error.code",
"maxRefreshTryCount": 5,
"tokenResponsePath": "access_token",
"tokenType": "Bearer",
"retryFailureStatusCode": [401],
"accessToken": "Bearer token"
}
}
}

"ImportAccountEntJSON": {
"accountParams": {
"processingType":"SequentialAndIterative",
"connection": "OSService",
"createUsers": false,
"call": {
"call1": {
"http": {
"url": "https://hostname/api/getAllUsers",
"basicUrl": "<domain name>",
"hostUrl": "/api/getAllUsers",
"httpContentType": "application/json",
"httpMethod": "POST",
"httpHeaders": {
"Authorization": "${access_token}"
},
"httpParams": "{\"connectionInfo\": {\"host\": \"${connection.ConnectionInfo.host}\",
\"port\": \"${connection.ConnectionInfo.port}\",
\"authMethod\": \"${connection.ConnectionInfo.authMethod}\"
},\"customFilter\": {\"attribute_name\": \"uid\", \"filter_operator\": \"notstartswith\", \"values\": [\"T\", \"@T\", \"$T\"]}

}"

},
"listField": "result",
"keyField": "accountID",
"colsToPropsMap": {
"accountID": "uid~#~char",
"name": "username~#~char",
"displayName": "username~#~char",
"status": "#CONST#true~#~char"
}}}
}
}

Thanks in advance.

Regards,

Lynn

[sudeshjaiswal]

Hello @Lynn,

Can you provide the screenshot of the Body of HTTP Paramater from the ImportAccountEntJSON,
Also to pass the information from the connection json to importaccountjson, woud be as as below..

"ConnectionJSON": {
    "authentications": {
        "OSService": {
            "authType": "oauth2",
            "url": "https://hostname/api/TestConnection",
            "httpParams": {
                "password": "Snp@ssw0rd",
                "grant_type": "password",
                "scope": "useraccount",
                "client_id": "3c774f2fb7e83110cdb30652042d0ba9",
                "client_secret": "`$v9R3m7[O",
                "username": "admin"

            },
            
                "host": "host70.ca",
                "port": "443",
                "authMethod": "password"
            
            "httpHeaders": {
                "Content-Type": "application/x-www-form-urlencoded"
            },
            "authError": [
                "InvalidAuthenticationToken"],
            "httpMethod": "POST",
            "httpContentType": "application/x-www-form-urlencoded",
            "errorPath": "error.code",
            "maxRefreshTryCount": 5,
            "tokenResponsePath": "access_token",
            "tokenType": "Bearer",
            "retryFailureStatusCode": [401],
            "accessToken": "Bearer token"
        }
    }
}

"ImportAccountEntJSON": {
    "accountParams": {
        "processingType": "SequentialAndIterative",
        "connection": "OSService",
        "createUsers": false,
        "call": {
            "call1": {
                "http": {
                    "url": "https://hostname/api/getAllUsers",
                    "basicUrl": "<domain name>",
                    "hostUrl": "/api/getAllUsers",
                    "httpContentType": "application/json",
                    "httpMethod": "POST",
                    "httpHeaders": {
                        "Authorization": "${access_token}"
                    },
                    "httpParams": "{\"connectionInfo\": {\"host\": \"${connection.host}\",
                    \"port\": \"${connection.port}\",
                    \"authMethod\": \"${connection.authMethod}\"
                    },\"customFilter\": {\"attribute_name\": \"uid\", \"filter_operator\": \"notstartswith\", \"values\": [\"T\", \"@T\", \"$T\"]}

                    }"

                },
                "listField": "result",
                "keyField": "accountID",
                "colsToPropsMap": {
                    "accountID": "uid~#~char",
                    "name": "username~#~char",
                    "displayName": "username~#~char",
                    "status": "#CONST#true~#~char"
                }
            }
        }
    }
}

Thanks.

[Lynn]

Hello @sudeshjaiswal ,

I tried your suggestion, but still got the same issue.

Below is the screenshot of postman, postman is working fine. the issue is the variable binding for $.

Many thanks.

Regards,

Lynn

[sk]

@Lynn : Did you try single slash (\)

[Lynn]

\\$ is working:

Regards,

Lynn

[Lynn]

Hi @sk,

Is this a bug? using postman, I don't need to specify double slash \\.

Regards,

Lynn

[rushikeshvartak]

\\$ Should work & its expected to escape character. $ character is used by product to evaluate dynamic value in connector hence its expected and not bug.

[sk]

@Lynn : Nope that is expected behaviour. Because system uses $ to evaluate dynamic values so to avoid that we need to give escape characters(\\)