Salesforce : Concatenation issue in workflow

Identity Security Cloud (ISC) ISC Discussion and Questions
,
1

HI Team,
We need to retrieve the ID from the UserLogin table using the UserId from the User table in Salesforce.

  • Variable A: API to fetch the UserLogin ID
  • Variable B: Expression to extract the UserId from the User table within Salesforce

Please review and provide your inputs. Below is the code:
{
“name”: “URL”,
“description”: “Building dynamic URL to fetch userlogin.Id from userlogin table”,
“transforms”: [
{
“id”: “sp:transform:concatenate:string”,
“input”: {
“index”: 0,
“variableB.$”: “$.accountRequests[?(@.source.id==‘xyz’)].accountId”
}
},
{
“id”: “sp:transform:concatenate:string”,
“input”: {
“variableB”: “'”
}
}
],
“variableA”: “xxx.salesforce.com/services/data/v61.0/query/?q=select+ID+FROM+UserLogin+WHERE+UserId='"
}

2

getting below error:

image
image1154×900 56.3 KB

3

Is the UserId from the User table in Salesforce a string or a number (like account id number or employee id number)?

4

Its a string. Not a number.

5

It seems that the part “index=0” is incorrectly placed in variableB.

6

Can you please guide what should the index then?

8

I’m getting the same error. Has anyone figured out a solution for this?

image
image1537×806 45.1 KB

Define Variable defined:

{
  "name": "groupName",
  "description": "",
  "transforms": [
    {
      "id": "sp:transform:concatenate:string",
      "input": {
        "variableB": "_"
      }
    },
    {
      "id": "sp:transform:concatenate:string",
      "input": {
        "variableB.$": "$.identity.firstname"
      }
    }
  ],
  "variableA": "DL_Direct_Rpts "
}