I have created a Turbo Extract Data Mapper to get Accounts Fields Like Name and Industry.
I have taken Extraction Object as Account, Extract Object Path as Accounts, I have not taken any filter, my Related Object is Account as It's mandatory to select and Selected Fields are Name and Industry.
While click on preview and after executing this logic I'm facing this error message:
{
"fetchAcc": {
"all": {
"0": "Critical Error: We couldn’t execute the Data Mapper because the mappings are incorrect. Verify the mappings and try again. If the issue persists, contact Salesforce Customer Support."
}
}
}
I have done same thing with custom JSON while applying filter to get records of particular accounts, that is working fine.
To get records of Accounts, I have check another way to
where I'm just applying filter Id != "$VLOCITY>NULL" and every thing is same as above here I'm getting this error
{
"FetchAccs": {
"all": {
"0": "OmniStudio Query Error: ; nested exception is: \n\tcommon.exception.ApiQueryException: \nType,Name FROM Account WHERE (Id != '$VLOCITY.NULL') LIMIT 50000\n ^\nERROR at Row:1:Column:41\ninvalid ID field: $VLOCITY.NULL"
}
}
}
In SOQL it's normal logic "Select Id, Name, Industry from Account Where Id != null" but it's not working in omnistudio.
What wrong I'm doing ? Please Help me
Assuming that you are trying to extract all accounts, use the filter
Id Not Equal To "$Vlocity.null"
Note: you need the double qoutes around $Vlocity.null. Refer to the screenshot below.
You may also use an empty double quote to attain the same result.
Id Not Equal To ""