Forum Discussion
CRM connection Query Needed !
Hello,
Right now I am connecting to CRM dynamics using Odata Feed and here is the query which is working.
https://cne*******.com/XRMServices/2011/OrganizationData.svc/cdi_surveyanswerSet?$filter=statecode/Value eq 0&$select=cdi_Value,cdi_surveyanswerid,cdi_PostedSurveyId,cdi_contact_cdi_postedsurvey,cdi_question
Here's the thing I need to know,
1. I imported all the table called "cdi_surveyanswerSet" and got the column names from there but it says invalid column name "cdi_surveyanswerid" of table "cdi_surveyanswerSet", where to check what's the exact column name.
2. I wanted to apply filter like cdi_question = "Some String" and cdi_modified_on > (sysdate() -1) just like we do in SQL
Could you please help me with my query ?
You should not write your query into your OData connection string. Just connect and use the query builder to pick a table and select columns. The query editor has a full set of tools for doing this which allows you to see the names of the columns so you don't get errors that you can't diagnose. See my answer in your other thread.
1 Reply
You should not write your query into your OData connection string. Just connect and use the query builder to pick a table and select columns. The query editor has a full set of tools for doing this which allows you to see the names of the columns so you don't get errors that you can't diagnose. See my answer in your other thread.