none
External content type based on OData is invisible in SPD2013 (but visible in a web browser)

    Question

  • I am trying to connect external list based on OData to Outlook, I could create it, but can't map its fields to Office Item type because it is invisible in SPD2013.

    I've made screenshots of all the steps to repeat the issue.

    **STEP1. Create BDC model. You can skip this step and download bdcm file here**

    1. Create new SharePoint 2013 app project.


    2. Add new Item / Content Types for an External Data Source

    3. Add test OData service info.


    4. Select the only entity - Regions


    5. Press the Deploy button (to generate WSP where we can get bdcm file), like it shown in this article.

    At the end of this step I have BDCMetadata.bdcm file, which I get from the myproject.wsp\MyFeature\External Content Types.

    **STEP2. Import the model to Business Data Connectivity Service.**

     1. Go to the Central Administration \ Application Management \ Manage Service Applications \ Bussiness Data Connectivity Service \ Import.


     2. Choose my bdcm file and press the Import button.


     3. After  that I can see my model in Web Browser.

    But I can't see it in SPD2013. 



    **What I tried**

    - press the refresh button, trying to make a clean installation of the SPD to another machine. Result is the same, I can't see it.
    - create External list using a web browser (Settings \ Add an app \ External list). I could see external content type 



    and even could create list, which worked well.



    I can see this external list in SPD2013 too, but all the same I can't see the external content type.

    **Does anybody have any ideas?**
    Every suggestions are very appreciated.

    **UPDATE1**: Maybe there is another way to map external content type to the Office Item type without using SPD?

    PS: I am not sure if it is a right place to ask this question. If somebody sure it is better to place it in the SharePoint 2013 - Using SharePoint Designer, InfoPath and Other Customizations thread. Let me know.


    Regards, Michael (http://sp2013-blog.com)
    • Edited by MikhailSP Saturday, March 09, 2013 10:42 PM
    Wednesday, November 28, 2012 8:55 AM

Answers

All replies

  • Unfortunately, it seems that it happens because SPD2013 doesn't support OData. So possibly somebody knows the answer on the following question: Is it possible to map External Content Type to Office Item Type without using SharePoint Designer?

    Regards, Michael (http://sp2013-blog.com)

    • Marked as answer by MikhailSP Thursday, November 29, 2012 10:58 AM
    • Edited by MikhailSP Saturday, March 09, 2013 10:43 PM
    Thursday, November 29, 2012 10:58 AM
  • Hi,

         It seems that the BCS model is created on Microsoft Online, with reference to the BCS url  http://pastebin.com/6LzbQYWy, the AccessControlEntry says, all the authenticated users should have 

    1. <AccessControlList>
    2.         <AccessControlEntry Principal="STS|SecurityTokenService|http://sharepoint.microsoft.com/claims/2009/08/isauthenticated|true|http://www.w3.org/2001/XMLSchema#string">
    3.           <Right BdcRight="Edit" />
    4.           <Right BdcRight="Execute" />
    5.           <Right BdcRight="SelectableInClients" />
    6.           <Right BdcRight="SetPermissions" />
    7.         </AccessControlEntry>
    8.       </AccessControlList>

    means all the authenticated user should be able to operate on BCS entities. Please check for the Meta Data Permission and Object permission on Microsoft Online BCS administration page and check for log-in you are using to log-in on SPD has appropriate permission set on the Object and entities. If not please set the appropriate permission and check for the issue.

    Regards,

    Ajeet 


    If my post is helpful - please click on the green arrow to mark it as answer

    Thursday, November 29, 2012 11:12 AM
  • Hi Ajeet.

    Thank you very much for your answer. 

    I am new to claims-based authentication. Sorry if I misunderstood your question.

    Actually, I use not SharePoint online, but local installation of the farm (on my server, not on the same machine where SPD is installed). It seems that I have enough access to this ECT (I can create external list from it using web browser and the same account). How I set access:

    Opened Central administration \ Application management \ Manage Service applications \ BCS Service, select 

    this External Content Type, and added my account in both Object Permissions and Metadata Store Permissions.

    In both places I selected all the check boxes.

    Am I understand your proposition correctly? 

    Or maybe you have some another ideas?

    Thank you in advance.

    Kind regards, 

    Michael (http://sp2013-blog.com)




    • Edited by MikhailSP Saturday, March 09, 2013 10:43 PM
    Thursday, November 29, 2012 12:52 PM