{"action":"created","issue":{"url":"https://api.github.com/repos/dreamfactorysoftware/dreamfactory/issues/9","labels_url":"https://api.github.com/repos/dreamfactorysoftware/dreamfactory/issues/9/labels{/name}","comments_url":"https://api.github.com/repos/dreamfactorysoftware/dreamfactory/issues/9/comments","events_url":"https://api.github.com/repos/dreamfactorysoftware/dreamfactory/issues/9/events","html_url":"https://github.com/dreamfactorysoftware/dreamfactory/issues/9","id":113039949,"number":9,"title":"MSSQL Tables not being found","user":{"login":"wcjr","id":4412848,"avatar_url":"https://avatars.githubusercontent.com/u/4412848?v=3","gravatar_id":"","url":"https://api.github.com/users/wcjr","html_url":"https://github.com/wcjr","followers_url":"https://api.github.com/users/wcjr/followers","following_url":"https://api.github.com/users/wcjr/following{/other_user}","gists_url":"https://api.github.com/users/wcjr/gists{/gist_id}","starred_url":"https://api.github.com/users/wcjr/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/wcjr/subscriptions","organizations_url":"https://api.github.com/users/wcjr/orgs","repos_url":"https://api.github.com/users/wcjr/repos","events_url":"https://api.github.com/users/wcjr/events{/privacy}","received_events_url":"https://api.github.com/users/wcjr/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/dreamfactorysoftware/dreamfactory/labels/bug","name":"bug","color":"fc2929"}],"state":"open","locked":false,"assignee":{"login":"jstablesdf","id":9806362,"avatar_url":"https://avatars.githubusercontent.com/u/9806362?v=3","gravatar_id":"","url":"https://api.github.com/users/jstablesdf","html_url":"https://github.com/jstablesdf","followers_url":"https://api.github.com/users/jstablesdf/followers","following_url":"https://api.github.com/users/jstablesdf/following{/other_user}","gists_url":"https://api.github.com/users/jstablesdf/gists{/gist_id}","starred_url":"https://api.github.com/users/jstablesdf/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/jstablesdf/subscriptions","organizations_url":"https://api.github.com/users/jstablesdf/orgs","repos_url":"https://api.github.com/users/jstablesdf/repos","events_url":"https://api.github.com/users/jstablesdf/events{/privacy}","received_events_url":"https://api.github.com/users/jstablesdf/received_events","type":"User","site_admin":false},"milestone":null,"comments":3,"created_at":"2015-10-23T15:12:24Z","updated_at":"2015-10-28T19:37:00Z","closed_at":null,"body":"Swagger docs are bringing back all our tables but when trying to get data from one of those tables (again using the swagger docs), there is a strange failure about the API not being able to find the table (which was provided in the dropdown of tables within the swagger docs).\r\n\r\nfurther details in http://community.dreamfactory.com/t/ms-sql-tables-being-returned-but-no-data-within-them-in-2-0/1639"},"comment":{"url":"https://api.github.com/repos/dreamfactorysoftware/dreamfactory/issues/comments/151967210","html_url":"https://github.com/dreamfactorysoftware/dreamfactory/issues/9#issuecomment-151967210","issue_url":"https://api.github.com/repos/dreamfactorysoftware/dreamfactory/issues/9","id":151967210,"user":{"login":"hasansahmad","id":12295646,"avatar_url":"https://avatars.githubusercontent.com/u/12295646?v=3","gravatar_id":"","url":"https://api.github.com/users/hasansahmad","html_url":"https://github.com/hasansahmad","followers_url":"https://api.github.com/users/hasansahmad/followers","following_url":"https://api.github.com/users/hasansahmad/following{/other_user}","gists_url":"https://api.github.com/users/hasansahmad/gists{/gist_id}","starred_url":"https://api.github.com/users/hasansahmad/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/hasansahmad/subscriptions","organizations_url":"https://api.github.com/users/hasansahmad/orgs","repos_url":"https://api.github.com/users/hasansahmad/repos","events_url":"https://api.github.com/users/hasansahmad/events{/privacy}","received_events_url":"https://api.github.com/users/hasansahmad/received_events","type":"User","site_admin":false},"created_at":"2015-10-28T19:37:00Z","updated_at":"2015-10-28T19:37:00Z","body":"SQL Server 2008 R2 - Developer Edition - x64\r\nWindows 7 Ultimate - x64\r\nDreamFactory - 2.0 beta 4\r\nBitnami Stack - x86\r\n\r\nService Driver - MS SQL Server (via sqlsrv)\r\nConnection String - sqlsrv:Server=localhost,1433\\sql2008;Database=Ascend_Santmyer_Cur\r\nUsername - sa\r\nPassword - **************\r\n\r\nRole Component - *\r\nRole Access - Get\r\nRequester - API\r\n\r\ngetTables() List - http://127.0.0.1:82/api/v2/Santmyer/_table - Works\r\ngetProcs(), callStoredProc(), callStoredFunc() - Works\r\n\r\ngetRecords() - http://127.0.0.1:82/api/v2/Santmyer/_table/OrderOEStatus - Fails with error in last post. I created a stored procedure to select * from OrderOEStatus table and that works fine. Same thing happens on all other tables from the Swagger - API Docs page or from another client/tool like Chrome App - Postman\r\n"}}