# \#api-driver **URL:** https://community.cdata.com/tag/api-driver/113.md [Latest](https://community.cdata.com/latest.md) · [Categories](https://community.cdata.com/categories.md) · [Tags](https://community.cdata.com/tags.md) --- ## [How to Connect API Data sources to Power BI using CData API Driver](https://community.cdata.com/t/how-to-connect-api-data-sources-to-power-bi-using-cdata-api-driver/1298)
**Author:** [@Anusha\_M\_B](https://community.cdata.com/u/Anusha_M_B)\ **Replies:** 0\ **Last updated:** [June 2, 2026, 10:10am UTC](https://community.cdata.com/t/how-to-connect-api-data-sources-to-power-bi-using-cdata-api-driver/1298 "2026-06-02T10:10:22Z")
Skip the custom connector. The CData API Driver pulls REST API data directly into Power BI in a few steps. For more information, refer to: How to Connect API Data Sources to Power BI Using CData API Driver --- ## [Authenticate and Access Zoom API with OAuth and Postman](https://community.cdata.com/t/authenticate-and-access-zoom-api-with-oauth-and-postman/1138)
**Author:** [@Anusha\_M\_B](https://community.cdata.com/u/Anusha_M_B)\ **Replies:** 0\ **Last updated:** [July 25, 2025, 5:41am UTC](https://community.cdata.com/t/authenticate-and-access-zoom-api-with-oauth-and-postman/1138 "2025-07-25T05:41:46Z")
Hey CData Community! If you’re working with the Zoom API and need a secure way to test endpoints, this quick guide is for you. It covers setting up OAuth credentials, making API calls in Postman, and connecting via CDat… --- ## [JIRA Worklog Table Timeout](https://community.cdata.com/t/jira-worklog-table-timeout/621)
**Author:** [@Newbie\_Cdata](https://community.cdata.com/u/Newbie_Cdata)\ **Replies:** 1\ **Last updated:** [February 1, 2024, 4:36pm UTC](https://community.cdata.com/t/jira-worklog-table-timeout/621 "2024-02-01T16:36:08Z")
Trying to bring JIRA data onto snowflake using CData. All the tables loaded successfully except Worklog. The worklog table failed with below error. \[0\] \[500\] Could not execute the specified command: Failed to cache ro… --- ## [ODBC drivers in Polybase - Issue creating an external table with mismatched metadata](https://community.cdata.com/t/odbc-drivers-in-polybase-issue-creating-an-external-table-with-mismatched-metadata/381)
**Author:** [@LaurenH](https://community.cdata.com/u/LaurenH)\ **Replies:** 0\ **Last updated:** [September 6, 2023, 9:05pm UTC](https://community.cdata.com/t/odbc-drivers-in-polybase-issue-creating-an-external-table-with-mismatched-metadata/381 "2023-09-06T21:05:40Z")
An error will be thrown when the column metadata defined in the CREATE EXTERNAL TABLE statement does not match the driver’s reported column metadata in the source table. The error will detail which columns are mismatched… --- ## [ODBC drivers in Polybase: File path permissions should match the user accessing them with the identity of the SQL Server process](https://community.cdata.com/t/odbc-drivers-in-polybase-file-path-permissions-should-match-the-user-accessing-them-with-the-identity-of-the-sql-server-process/335)
**Author:** [@LaurenH](https://community.cdata.com/u/LaurenH)\ **Replies:** 0\ **Last updated:** [August 16, 2023, 6:12pm UTC](https://community.cdata.com/t/odbc-drivers-in-polybase-file-path-permissions-should-match-the-user-accessing-them-with-the-identity-of-the-sql-server-process/335 "2023-08-16T18:12:08Z")
When accessing CSV, Excel, etc files using Polybase, those drivers are typically configured with file paths, note that the identity of the user accessing those files with be the identity of the SQL Server process so make… --- ## [ODBC drivers in Polybase: Changes with connection settings and metadata are not reflected](https://community.cdata.com/t/odbc-drivers-in-polybase-changes-with-connection-settings-and-metadata-are-not-reflected/334)
**Author:** [@LaurenH](https://community.cdata.com/u/LaurenH)\ **Replies:** 0\ **Last updated:** [August 16, 2023, 5:35pm UTC](https://community.cdata.com/t/odbc-drivers-in-polybase-changes-with-connection-settings-and-metadata-are-not-reflected/334 "2023-08-16T17:35:34Z")
Issue: Sometimes, changes to a DSN meant to change driver behavior, how metadata is exposed, or what metadata exists will not be immediately apparent when the driver is used from Polybase. In those cases, Polybase likely… --- ## [ODBC drivers in Polybase: Object reference error occurring when creating external table](https://community.cdata.com/t/odbc-drivers-in-polybase-object-reference-error-occurring-when-creating-external-table/331)
**Author:** [@LaurenH](https://community.cdata.com/u/LaurenH)\ **Replies:** 0\ **Last updated:** [August 14, 2023, 8:51pm UTC](https://community.cdata.com/t/odbc-drivers-in-polybase-object-reference-error-occurring-when-creating-external-table/331 "2023-08-14T20:51:06Z")
Error: “Object reference not set to an instance of an object.” Cause will depend on situation, check driver any polybase logs. Some possible causes include: A User DSN was specified within the CONNECTION\_OPTIONS of t… --- ## [ODBC drivers in Polybase: Object reference error occurring when creating external table](https://community.cdata.com/t/odbc-drivers-in-polybase-object-reference-error-occurring-when-creating-external-table/330)
**Author:** [@LaurenH](https://community.cdata.com/u/LaurenH)\ **Replies:** 0\ **Last updated:** [August 14, 2023, 6:51pm UTC](https://community.cdata.com/t/odbc-drivers-in-polybase-object-reference-error-occurring-when-creating-external-table/330 "2023-08-14T18:51:27Z")
Error: “Object reference not set to an instance of an object.” Cause will depend on situation, check driver any polybase logs. Some possible causes include: A User DSN was specified within the CONNECTION\_OPTIONS of t… --- ## [ODBC drivers in Polybase: Avoiding issues with NVARCHAR columns](https://community.cdata.com/t/odbc-drivers-in-polybase-avoiding-issues-with-nvarchar-columns/329)
**Author:** [@LaurenH](https://community.cdata.com/u/LaurenH)\ **Replies:** 0\ **Last updated:** [August 14, 2023, 6:13pm UTC](https://community.cdata.com/t/odbc-drivers-in-polybase-avoiding-issues-with-nvarchar-columns/329 "2023-08-14T18:13:52Z")
Polybase has a maximum row size of 32 KB in SQL Server (or 1 MB in Azure Synapse Analytics). As a good rule of thumb, when creating NVARCHAR columns with the CREATE EXTERNAL TABLE statement, set the size to 255 unless yo… --- ## [The query requires Id in the where clause: API Driver](https://community.cdata.com/t/the-query-requires-id-in-the-where-clause-api-driver/281)
**Author:** [@Altin](https://community.cdata.com/u/Altin)\ **Replies:** 0\ **Last updated:** [July 24, 2023, 5:19pm UTC](https://community.cdata.com/t/the-query-requires-id-in-the-where-clause-api-driver/281 "2023-07-24T17:19:14Z")
There are cases when the profile, could support IN operator in the Where clause, so you can run a query like: Select \* From \ Where \ IN (Select Id from \) or just simply: Select \* From \ … --- ## [404 NOT Found error instead of returning 0 results](https://community.cdata.com/t/404-not-found-error-instead-of-returning-0-results/268)
**Author:** [@Altin](https://community.cdata.com/u/Altin)\ **Replies:** 0\ **Last updated:** [July 19, 2023, 5:54pm UTC](https://community.cdata.com/t/404-not-found-error-instead-of-returning-0-results/268 "2023-07-19T17:54:31Z")
If the service returns a 404 NOT Found error instead of returning 0 results, and you don’t want the driver to throw that error, then you can set ‘KeyNotFoundStatusCodes=404’ in Other property, i.e.: Other=’KeyNotFoundSta… --- ## [How to Create API Driver API Profiles](https://community.cdata.com/t/how-to-create-api-driver-api-profiles/121)
**Author:** [@jerodj-cdata](https://community.cdata.com/u/jerodj-cdata)\ **Replies:** 0\ **Last updated:** [March 30, 2023, 12:59pm UTC](https://community.cdata.com/t/how-to-create-api-driver-api-profiles/121 "2023-03-30T12:59:56Z")
RESTful APIs offer a consistent, straightforward way for businesses to work with external data and offer access to their own data. In June 2019, the number of public APIs grew beyond 22,000, with a growth rate of more th…