# APIs & Connectors **URL:** https://visier.discourse.group/c/alpine-and-apis/4.md [Latest](https://visier.discourse.group/latest.md) · [Categories](https://visier.discourse.group/categories.md) · [Tags](https://visier.discourse.group/tags.md) --- ## [Welcome to Visier! 👋](https://visier.discourse.group/t/welcome-to-visier/5)
**Author:** [@system](https://visier.discourse.group/u/system)\ **Replies:** 0\ **Last updated:** [October 18, 2023, 8:24pm UTC](https://visier.discourse.group/t/welcome-to-visier/5 "2023-10-18T20:24:55Z")
We are so glad you joined us. Visier A place for Visier developers to learn, give feedback, and grow together. Here are some things you can do to get started: :speaking\_head: Introduce yourself by adding your pictur… --- ## [About the APIs & Connectors category](https://visier.discourse.group/t/about-the-apis-connectors-category/3)
**Author:** [@system](https://visier.discourse.group/u/system)\ **Replies:** 0
Welcome to the APIs & Connectors discussion forum – your collaborative space for conversations centered around Visier’s data integration and interfacing capabilities. Here, you can share your experiences, seek advice, an… --- ## [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:** 1\ **Last updated:** [February 16, 2026, 10:21pm UTC](https://visier.discourse.group/t/sql-like-with-api-connector/405 "2026-02-16T22:21:28Z")
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… --- ## [PLF0018011 rci code while creating non-versioned permissions](https://visier.discourse.group/t/plf0018011-rci-code-while-creating-non-versioned-permissions/400)
**Author:** [@b.fidrysiak](https://visier.discourse.group/u/b.fidrysiak)\ **Replies:** 0\ **Last updated:** [October 31, 2025, 12:22pm UTC](https://visier.discourse.group/t/plf0018011-rci-code-while-creating-non-versioned-permissions/400 "2025-10-31T12:22:31Z")
What PLF0018011 rci code mean in response to updating non-versioned permissions via public API? --- ## [RCIY60200032 code meaning](https://visier.discourse.group/t/rciy60200032-code-meaning/388)
**Author:** [@b.fidrysiak](https://visier.discourse.group/u/b.fidrysiak)\ **Replies:** 1\ **Last updated:** [August 5, 2025, 5:28pm UTC](https://visier.discourse.group/t/rciy60200032-code-meaning/388 "2025-08-05T17:28:05Z")
Can you conifm that RCIY60200032 is returned by Visier public API only and only in situation when request to project public API is rejected due to an attempt of publishing empty project (In case of other project API publ… --- ## [POST /v1/op/data/startExtractAndLoad request body definition is invalid](https://visier.discourse.group/t/post-v1-op-data-startextractandload-request-body-definition-is-invalid/355)
**Author:** [@b.zafirov](https://visier.discourse.group/u/b.zafirov)\ **Replies:** 1\ **Last updated:** [January 6, 2025, 6:03pm UTC](https://visier.discourse.group/t/post-v1-op-data-startextractandload-request-body-definition-is-invalid/355 "2025-01-06T18:03:10Z")
Hello Visier Developer community, after testing the latest version of the data-in-apis.yaml (available here) OAS3 spec, we found out that the request body definition for the POST /v1/op/data/startExtractAndLoad\` is inva… --- ## [Snowflake DataIn Connector Missing Data](https://visier.discourse.group/t/snowflake-datain-connector-missing-data/318)
**Author:** [@Austin.Martin](https://visier.discourse.group/u/Austin.Martin)\ **Replies:** 3\ **Last updated:** [August 29, 2024, 12:01am UTC](https://visier.discourse.group/t/snowflake-datain-connector-missing-data/318 "2024-08-29T00:01:58Z")
Hello, Checking to see if anyone else has successfully setup a data feed to Visier with the Extend using the Snowflake API? We have successfully made a connection to our Snowflake instance and are able to execute data e… --- ## [Paging in GET /v1/op/jobs/dispatching-jobs/{jobId}/processing-jobs doesn't work](https://visier.discourse.group/t/paging-in-get-v1-op-jobs-dispatching-jobs-jobid-processing-jobs-doesnt-work/255)
**Author:** [@b.zafirov](https://visier.discourse.group/u/b.zafirov)\ **Replies:** 3\ **Last updated:** [May 28, 2024, 3:46pm UTC](https://visier.discourse.group/t/paging-in-get-v1-op-jobs-dispatching-jobs-jobid-processing-jobs-doesnt-work/255 "2024-05-28T15:46:59Z")
Dear Visier developer community, As specified in the Data and Job Handling API in order to get the status for the processing jobs (for a dispatching job), one can call the endpoint GET /v1/op/jobs/dispatching-jobs/{jobI… --- ## [Trigger extraction jobs endpoint has incorrect OAS3 definition](https://visier.discourse.group/t/trigger-extraction-jobs-endpoint-has-incorrect-oas3-definition/256)
**Author:** [@b.zafirov](https://visier.discourse.group/u/b.zafirov)\ **Replies:** 5\ **Last updated:** [May 15, 2024, 4:29pm UTC](https://visier.discourse.group/t/trigger-extraction-jobs-endpoint-has-incorrect-oas3-definition/256 "2024-05-15T16:29:03Z")
Dear Visier developer community, After calling the endpoint POST /v1/op/data/startExtractAndLoad we have noticed that the endpoint doesn’t accept application/json request body, but it accepts multipart/form-data. Theref… --- ## [POST /v2/admin/users fails to create users with non-alphanumeric characters](https://visier.discourse.group/t/post-v2-admin-users-fails-to-create-users-with-non-alphanumeric-characters/244)
**Author:** [@b.zafirov](https://visier.discourse.group/u/b.zafirov)\ **Replies:** 3\ **Last updated:** [May 10, 2024, 7:40pm UTC](https://visier.discourse.group/t/post-v2-admin-users-fails-to-create-users-with-non-alphanumeric-characters/244 "2024-05-10T19:40:18Z")
Hello Visier Developer community, After calling the endpoint POST /v2/admin/users with the following payload: { "users": \[ { "username": "VALID\_USERNAME", "displayName": "Test & Tester", "employeeId": "VALI… --- ## [Data and Job Handling API OAS3 schema errors](https://visier.discourse.group/t/data-and-job-handling-api-oas3-schema-errors/249)
**Author:** [@b.zafirov](https://visier.discourse.group/u/b.zafirov)\ **Replies:** 4\ **Last updated:** [May 9, 2024, 12:04am UTC](https://visier.discourse.group/t/data-and-job-handling-api-oas3-schema-errors/249 "2024-05-09T00:04:50Z")
Dear Visier developer community, After starting to use the Data and Job Handling API we have found out that the OAS3 schema provided here has invalid definitions for some of the endpoints in the API. For instance the e… --- ## [Update user API has incorrect OAS3 definition](https://visier.discourse.group/t/update-user-api-has-incorrect-oas3-definition/251)
**Author:** [@b.zafirov](https://visier.discourse.group/u/b.zafirov)\ **Replies:** 2\ **Last updated:** [May 3, 2024, 6:55am UTC](https://visier.discourse.group/t/update-user-api-has-incorrect-oas3-definition/251 "2024-05-03T06:55:56Z")
Dear Visier developer community, After calling the endpoint PUT /v1/admin/users/{userId} we have noticed that the endpoint doesn’t accept application/json request body (as specified here), but it accepts multipart/form… --- ## [Bulk creation API doesn't behave consistently](https://visier.discourse.group/t/bulk-creation-api-doesnt-behave-consistently/248)
**Author:** [@b.zafirov](https://visier.discourse.group/u/b.zafirov)\ **Replies:** 1\ **Last updated:** [April 25, 2024, 11:49pm UTC](https://visier.discourse.group/t/bulk-creation-api-doesnt-behave-consistently/248 "2024-04-25T23:49:35Z")
Hello Visier developer community , After using the endpoint POST /v2/admin/users we have experienced that the endpoint doesn’t behave consistently when the field username is populated with lower or capital case charact… --- ## [Connector Credential Requirements for Microsoft 365 (Beta)](https://visier.discourse.group/t/connector-credential-requirements-for-microsoft-365-beta/250)
**Author:** [@mangopudding](https://visier.discourse.group/u/mangopudding)\ **Replies:** 0\ **Last updated:** [April 25, 2024, 9:35pm UTC](https://visier.discourse.group/t/connector-credential-requirements-for-microsoft-365-beta/250 "2024-04-25T21:35:20Z")
Hi! What are the connector credential requirements for using the Microsoft 365 Data Connector? Creating the app registration in Microsoft Entra ID is easy peasy part - but need to know what Microsoft API permissions ar… --- ## [Beta Connector - Microsoft 365](https://visier.discourse.group/t/beta-connector-microsoft-365/217)
**Author:** [@mangopudding](https://visier.discourse.group/u/mangopudding)\ **Replies:** 2\ **Last updated:** [April 5, 2024, 3:12pm UTC](https://visier.discourse.group/t/beta-connector-microsoft-365/217 "2024-04-05T15:12:57Z")
Hi Visiers! Where can I find more details about the data connector for Microsoft 365? I see it’s listed in beta. :slight\_smile: For creating the app registration, I’d like to know what scope of Microsoft API read pe… --- ## [Why doesn't my API user have the necessary permissions to perform data transfer operations?](https://visier.discourse.group/t/why-doesnt-my-api-user-have-the-necessary-permissions-to-perform-data-transfer-operations/31)
**Author:** [@christina.zhu](https://visier.discourse.group/u/christina.zhu)\ **Replies:** 0\ **Last updated:** [November 21, 2023, 7:23pm UTC](https://visier.discourse.group/t/why-doesnt-my-api-user-have-the-necessary-permissions-to-perform-data-transfer-operations/31 "2023-11-21T19:23:52Z")
The Data Transfer API is gated and requires separate access permissions; it is not included by default with the Data Query API rights. If you encounter permission issues, review the associated documentation for notes on … --- ## [How can I limit data extraction to only include records within specific dates?](https://visier.discourse.group/t/how-can-i-limit-data-extraction-to-only-include-records-within-specific-dates/30)
**Author:** [@christina.zhu](https://visier.discourse.group/u/christina.zhu)\ **Replies:** 0\ **Last updated:** [November 21, 2023, 7:13pm UTC](https://visier.discourse.group/t/how-can-i-limit-data-extraction-to-only-include-records-within-specific-dates/30 "2023-11-21T19:13:43Z")
Setting Parameters for Historical Data Extraction When you need to avoid extracting data from before a certain start date, consider the following: Specify a “Last Extract Date” upon the initial load to exclude employe… --- ## [What should I do if an extraction job rescheduling occurs?](https://visier.discourse.group/t/what-should-i-do-if-an-extraction-job-rescheduling-occurs/29)
**Author:** [@christina.zhu](https://visier.discourse.group/u/christina.zhu)\ **Replies:** 0\ **Last updated:** [November 21, 2023, 7:12pm UTC](https://visier.discourse.group/t/what-should-i-do-if-an-extraction-job-rescheduling-occurs/29 "2023-11-21T19:12:41Z")
Extraction jobs may be rescheduled for various reasons, including technical issues such as insufficient memory on the server. Rescheduling itself typically does not cause incorrect data to be reflected in the results. If… --- ## [Power BI isn't returning all records](https://visier.discourse.group/t/power-bi-isnt-returning-all-records/28)
**Author:** [@christina.zhu](https://visier.discourse.group/u/christina.zhu)\ **Replies:** 0\ **Last updated:** [November 21, 2023, 7:05pm UTC](https://visier.discourse.group/t/power-bi-isnt-returning-all-records/28 "2023-11-21T19:05:22Z")
If you’re experiencing an issue where a custom connector in Power BI does not return the complete set of expected records, consider the following points: User Permissions: Ensure that the permissions granted to the use… --- ## [How do I connect to a data source when I can't find the Visier Data Connector for Power BI?](https://visier.discourse.group/t/how-do-i-connect-to-a-data-source-when-i-cant-find-the-visier-data-connector-for-power-bi/27)
**Author:** [@christina.zhu](https://visier.discourse.group/u/christina.zhu)\ **Replies:** 0\ **Last updated:** [November 21, 2023, 6:59pm UTC](https://visier.discourse.group/t/how-do-i-connect-to-a-data-source-when-i-cant-find-the-visier-data-connector-for-power-bi/27 "2023-11-21T18:59:17Z")
If you’re having difficulty finding the Visier Data Connector in your list of sources after completing the preliminary setup steps, please review the following troubleshooting guide: Verify the Location of the Connecto… --- ## [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 …