{"id":530,"date":"2012-09-06T21:35:21","date_gmt":"2012-09-07T03:35:21","guid":{"rendered":"https:\/\/toddbaginski.com\/blog\/?p=530"},"modified":"2013-06-28T15:44:39","modified_gmt":"2013-06-28T21:44:39","slug":"accessing-bcs-external-data-from-an-app-for-sharepoint-2013","status":"publish","type":"post","link":"https:\/\/toddbaginski.com\/blog\/accessing-bcs-external-data-from-an-app-for-sharepoint-2013\/","title":{"rendered":"Accessing BCS External Data From An App For SharePoint 2013"},"content":{"rendered":"

If you are creating an App for SharePoint 2013 and plan to access BCS external data by using the REST API to query an external list, keep in mind that you must package your External Content Type in the SPAPP as well.  If you do not, you will see this error returned by your request to the REST service:<\/p>\n

Access denied. You do not have permission to perform this action or access this resource.<\/strong><\/p>\n

And you will see this error in the ULS logs when the query attempts to execute.<\/p>\n

System.UnauthorizedAccessException: Apps cannot use External Content Types defined in the Business Data Connectivity Shared Service Application metadata catalog. Apps should package any External Content Type definitions in a BDC model file which is packaged and deployed as part of the SharePoint App.<\/strong><\/p>\n

If you try to use the CSOM Javascript API you will get an error similar to this one:<\/p>\n

<\/p>\n

\nThe metadata catalog file BusinessDataMetadataCatalog\/BDCMetadata.bdcm could not be found on the site http:\/\/app-cbb5c08e54bb2a.apps.powder.ski\/BCSExternalDataSPApp.<\/p>\n

<\/strong><\/p>\n

Only 43 days until ski season!<\/p>\n","protected":false},"excerpt":{"rendered":"

If you are creating an App for SharePoint 2013 and plan to access BCS external data by using the REST API to query an external list, [\u2026]<\/span><\/p>\n","protected":false},"author":1,"featured_media":535,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[100,99],"tags":[28,10,30,7,68,71,72,70],"class_list":["post-530","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-bcs","category-sharepoint-2013","tag-bcs","tag-custom-development","tag-external-content-types","tag-sharepoint","tag-sharepoint-2013","tag-sharepoint-app","tag-sharepoint-hosted","tag-spapp"],"aioseo_notices":[],"aioseo_head":"\n\t\t\n\t\n\t\n\t\n\t\n\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t