Hi All,
I am trying to retrieve the ID from the UserLogin table (VariableA) by referencing the UserId (VariableB) from the User table in our Salesforce instance.
However, with the current implementation, the query is returning the same ID on every iteration instead of the expected unique values.
Could you please help identify the issue and suggest a fix?
{
“name”: “URL”,
“description”: “Building dynamic URL to fetch userlogin.Id from userlogin table”,
“transforms”: [
{
“id”: “sp:transform:concatenate:string”,
“input”: {
“variableB.$”: “$.getAccounts.accounts[1].attributes.Id”
}
},
{
“id”: “sp:transform:concatenate:string”,
“input”: {
“variableB”: “'”
}
}
],
“variableA”: “https://xxx.com/services/data/v61.0/query/?q=select+ID+FROM+UserLogin+WHERE+UserId='”
}