Execute SOQL - Unable to cast object of type'Newtonsoft.json.Linq.Jobject' to type 'Newtonsoft.Json.Linq.Property'

Help Studio
, ,
1

Hi,

I am using Execute SOQL from Salesforce package but the activity is throwing below error -
Execute SOQL - Unable to cast object of type’Newtonsoft.json.Linq.Jobject’ to type ‘Newtonsoft.Json.Linq.Property’

This activity is story the output in datatable variable.

For reference i am passing the query as -

Select Field1. Field2,(Select Field3, Field4 From Table2 where condition),(Select Field5, Field6 From Table3 where condition) From Table1 where Field1=“Value’”

My project is on windows compatibility .

Can you please help me on this.

Thank you.

2

just share with us some more details on what was modelled, especially on the failing part / variable definitions. Thanks

3

@ppr

I am storing the value of the query in a string variable and passing that variable in the activity Execute SOQL as an input

4

we were more interested on screenshots and espcially from where the cast issue is thrown. Above given description is too little

5

Sorry can’t provide you the screenshot as it is in client VDI.

This activity itself throwing this error.

I am passing the query in string format as an input to this activity and this activity itself throw the cast error .

6

Both the data type is different need to use same data type