Error in SOQL Query with Salesforce V2 dataset

Roxan Sadia 20

Hi,

I'm attempting to use the SOQL Query option to filter columns in the Salesforce dataset, but I'm running into the following error.
User's image

Any help would be appreciated. Thanks!

Roxan Sadia 20 Reputation points

2024-08-08T12:51:24.97+00:00

Also, I tried to remove the CAST and got this.

Please see the script that throwing the error below.
NIKHILA NETHIKUNTA 1,760 Reputation points Microsoft Vendor

2024-08-09T14:27:07.1766667+00:00

Hi @Roxan Sadia
Thank you for your question and using the Microsoft Q&A platform.

Can you try using the below expression:
Select field1,field2,.... fieldn from award__c where Cast(LastModified as Date) ='@{variable('datetoload')}'

You can refer to the below document for more information:
https://developer.salesforce.com/docs/atlas.en-us.soql_sosl.meta/soql_sosl/sforce_api_calls_soql_select_fields.htm
Hope this helps. Please let us know if the issue still persists.
Roxan Sadia 20 Reputation points

2024-08-09T14:52:50.1533333+00:00

Hi @NIKHILA NETHIKUNTA ,

Thank you for the quick response. However, I'm encountering an issue. Please note that I tried putting comma in everywhere within the part that throwing the issue but nothing worked.
Roxan Sadia 20 Reputation points

2024-08-12T06:57:58.7233333+00:00

Also getting this error
NIKHILA NETHIKUNTA 1,760 Reputation points Microsoft Vendor

2024-08-12T07:54:27.1+00:00

Hi @Roxan Sadia
Can you please try to remove the 'Concat' function and try? Please use the below expression without the CONCAT function:

Select field1,field2,.... fieldn from award__c where Cast(LastModified as Date) ='@{variable('datetoload')}'

Hope this helps. Please let us know if you have any further questions.
Roxan Sadia 20 Reputation points

2024-08-12T08:33:31.8033333+00:00

Thanks for the response. Another issue was encountered
NIKHILA NETHIKUNTA 1,760 Reputation points Microsoft Vendor

2024-08-13T04:52:11.5333333+00:00

Hi @Roxan Sadia
Try this:

The function is "variables" not variable. Please change it and try.
Hope this helps. Let us know if you have any further questions.
Roxan Sadia 20 Reputation points

2024-08-13T06:27:50.8266667+00:00

Hi @NIKHILA NETHIKUNTA ,

Thanks for your time in helping me solve the issue. However, issue still persists.

code:

error:

Do you think this has something to do with what Salesforce v2 can support? Though I haven't seen CAST on the list of what it doesn't support.
Roxan Sadia 20 Reputation points

2024-08-13T06:40:20.2466667+00:00

Hi @NIKHILA NETHIKUNTA ,

Thanks for your help in getting this issue resolved. However, issue still persists.
Code:

Error:

Do you think this has something to do with what Salesforce v2 can support? Though I haven't seen CAST included on the list of cannot be supported.
NIKHILA NETHIKUNTA 1,760 Reputation points Microsoft Vendor

2024-08-13T07:04:56.11+00:00

Hi @Roxan Sadia
Please try the query in salesforce environment directly by replacing the variable with the hardcoded value and see if it works there. If it's working there, it should work in ADF as well.

Please try this and let us know if the issue still persists:

Hope this helps.
NIKHILA NETHIKUNTA 1,760 Reputation points Microsoft Vendor

2024-08-14T18:31:42.4633333+00:00

Hi @Roxan Sadia
We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution please do share that same with the community as it can be helpful to others. Otherwise, will respond with more details and we will try to help.
NIKHILA NETHIKUNTA 1,760 Reputation points Microsoft Vendor

2024-08-16T00:04:29.07+00:00

Hi @Roxan Sadia
We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution, please do share that same with the community as it can be helpful to others. Otherwise, will respond with more details and we will try to help.
Roxan Sadia 20 Reputation points

2024-08-20T13:54:13.69+00:00

Hi @NIKHILA NETHIKUNTA ,

Thanks for your time responding to my queries.

My issue was resolved by using SOQL Date functions, as casting is not supported.
NIKHILA NETHIKUNTA 1,760 Reputation points Microsoft Vendor

2024-08-21T16:30:51.6666667+00:00

Hi @Roxan Sadia
Just checking in to see if the below answer helped. If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.

Accepted answer

NIKHILA NETHIKUNTA 1,760 Reputation points Microsoft Vendor

2024-08-20T16:23:07.7566667+00:00

@Roxan Sadia
I'm glad that you were able to resolve your issue and thank you for posting your solution so that others experiencing the same thing can easily reference this! Since the Microsoft Q&A community has a policy that "The question author cannot accept their own answer. They can only accept answers by others ", I'll repost your solution in case you'd like to accept the answer .

Ask: I'm attempting to use the SOQL Query option to filter columns in the Salesforce dataset, but I'm running into the following error:
Query Parsing Error: Unexpected token

Solution: The issue was resolved by using SOQL Date functions, as casting is not supported.

If I missed anything please let me know and I'd be happy to add it to my answer, or feel free to comment below with any additional information.

If you have any other questions, please let me know. Thank you again for your time and patience throughout this issue.

Please don’t forget to Accept Answer and Yes for "was this answer helpful" wherever the information provided helps you, this can be beneficial to other community members.
Please sign in to rate this answer.

1 person found this answer helpful.
NIKHILA NETHIKUNTA 1,760 Reputation points Microsoft Vendor

2024-08-22T18:15:54.0633333+00:00

Hi @Roxan Sadia
Just checking in to see if the above answer helped. If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

Share via

Error in SOQL Query with Salesforce V2 dataset

0 additional answers

Your answer