Using sdata for Custom Entity View

Hi, we have a client using v2018 R2 and have setup a view for a custom entity and marked it for use via sdata. When trying to use is via the webservice it always errors. Looking at the sql logs, the query is asking for some comp_ fields even though the company table is not referenced in the view. I started to add the comp_ fields and realised that it wanted me to add the entire company table fields. I don't understand why.

If I create a new view based on primary entity then every seems to work. Has anyone has any issues like this?

  • 0

    Gavriel

    Can I be clear what you are trying to do. I've just created a new custom entity in my system. I used the Advanced Customization Wizard. I marked it as exposed to SData and I then marked the automatically created view 'vMailMergeProject' as exposed to SData. I could access this view using without issue.

    SData 1.1

    http://[servername]/sdata/crmj/sagecrm/-/vMailMergeProject

    SData 2.0

    http://[servername]/sdata/crmj/sagecrm2/-/vMailMergeProject