# Data Export API **URL:** https://visier.discourse.group/c/alpine-and-apis/data-export-api/8.md [Latest](https://visier.discourse.group/latest.md) · [Categories](https://visier.discourse.group/categories.md) · [Tags](https://visier.discourse.group/tags.md) --- ## [About the Data Export API category](https://visier.discourse.group/t/about-the-data-export-api-category/19)
**Author:** [@christina.zhu](https://visier.discourse.group/u/christina.zhu)\ **Replies:** 0
Explore the possibilities of the Visier Data Export API with peers. Learn how others are efficiently extracting people analytics for use in external systems and share the innovative ways you are leveraging this API in yo… --- ## [SQL - Like with API connector](https://visier.discourse.group/t/sql-like-with-api-connector/405)
**Author:** [@Loutfi](https://visier.discourse.group/u/Loutfi)\ **Replies:** 2\ **Last updated:** [October 26, 2026, 2:51am UTC](https://visier.discourse.group/t/sql-like-with-api-connector/405 "2026-10-26T02:51:17Z")
Is there a way to view all the columns that make up a specific subject. For example when using SQL like, and plan to run top 10 records against subject “Employee” to view all the column in the table, i can’t just simply… --- ## [Handling API Authentication Issues](https://visier.discourse.group/t/handling-api-authentication-issues/26)
**Author:** [@christina.zhu](https://visier.discourse.group/u/christina.zhu)\ **Replies:** 0\ **Last updated:** [November 21, 2023, 6:51pm UTC](https://visier.discourse.group/t/handling-api-authentication-issues/26 "2023-11-21T18:51:42Z")
Q: What should users do when encountering credential type errors while connecting to data exports in Power BI? A: If a user is trying to perform a data export to Power BI and receives an error like “We were unable to co… --- ## [How can I find and manage a specific data export if all I have is its ID?](https://visier.discourse.group/t/how-can-i-find-and-manage-a-specific-data-export-if-all-i-have-is-its-id/25)
**Author:** [@christina.zhu](https://visier.discourse.group/u/christina.zhu)\ **Replies:** 0\ **Last updated:** [November 21, 2023, 6:30pm UTC](https://visier.discourse.group/t/how-can-i-find-and-manage-a-specific-data-export-if-all-i-have-is-its-id/25 "2023-11-21T18:30:24Z")
Currently, there isn’t a direct way within Studio to locate a Data Export by its ID. However, you can use a workaround: Enable browser diagnostics before opening the Data Export room. Within the diagnostic data, look f… --- ## [How can we set up a generic account to authenticate and pull exports programmatically?](https://visier.discourse.group/t/how-can-we-set-up-a-generic-account-to-authenticate-and-pull-exports-programmatically/24)
**Author:** [@christina.zhu](https://visier.discourse.group/u/christina.zhu)\ **Replies:** 0\ **Last updated:** [November 21, 2023, 6:29pm UTC](https://visier.discourse.group/t/how-can-we-set-up-a-generic-account-to-authenticate-and-pull-exports-programmatically/24 "2023-11-21T18:29:26Z")
To set up a generic account for data export, please follow these steps: Create a new user account by going to Studio \> Tenant. Detailed steps can be found in this knowledge base article Creating a New User Account. Lin… --- ## [What should I do if my data export stops working suddenly?](https://visier.discourse.group/t/what-should-i-do-if-my-data-export-stops-working-suddenly/23)
**Author:** [@christina.zhu](https://visier.discourse.group/u/christina.zhu)\ **Replies:** 0\ **Last updated:** [November 21, 2023, 6:22pm UTC](https://visier.discourse.group/t/what-should-i-do-if-my-data-export-stops-working-suddenly/23 "2023-11-21T18:22:06Z")
If your data export process is not working as expected and it’s impacting your reporting tools such as Power BI, here’s a multi-step action plan: Verify Export Layout Changes: Report layouts can unexpectedly change, po… --- ## [How can I export my data in JSON format using the API?](https://visier.discourse.group/t/how-can-i-export-my-data-in-json-format-using-the-api/22)
**Author:** [@christina.zhu](https://visier.discourse.group/u/christina.zhu)\ **Replies:** 0\ **Last updated:** [November 21, 2023, 6:12pm UTC](https://visier.discourse.group/t/how-can-i-export-my-data-in-json-format-using-the-api/22 "2023-11-21T18:12:12Z")
If you need to integrate your data with tools that require JSON format, our Export API provides a simple solution. When invoking the API, append the query string format=json to your request URL. This parameter instructs …