Hi , How can pull date from VAPI Dashboard to display it on PowerBI /Looker Studio ? @User @Vapi

@FaresAhmed Hello! To pull data from the VAPI Dashboard into PowerBI or Looker Studio, you'll typically need to use VAPI's API to export the data. Here's a general approach you can follow: 1. **API Access**: Ensure you have API access enabled on your VAPI account. You might need to generate an API key or use OAuth for authentication. 2. **API Endpoints**: Identify the API endpoints that provide the data you're interested in. The VAPI documentation should list these endpoints along with the required parameters and the format of the data. 3. **Data Connector**: Both PowerBI and Looker Studio have options to connect to external data sources via API. - For PowerBI, you can use the 'Get Data' feature and select 'Web' as the data source. Then you can provide the API URL and any necessary headers or parameters. - For Looker Studio (formerly Google Data Studio), you can use the 'Data Sources' feature and select the 'Web Connector' to connect to the API. 4. **Query and Import**: Construct the query using the API endpoint and fetch the data. You may need to handle pagination or filtering based on your needs. 5. **Visualization**: Once the data is imported into PowerBI or Looker Studio, you can create reports and dashboards as needed. If you need specific instructions or assistance with the API, please let me know, and I can provide more detailed guidance or direct you to the support team for further help.

Provid me URL for the documentation to pull data @Vapi

@FaresAhmed Certainly! You can find the documentation to pull data from VAPI for integration with services like PowerBI or Looker Studio at the following URL: [List Calls - Vapi Documentation](https://docs.vapi.ai/api-reference/calls/list-calls) This page will provide you with details on how to list calls using the VAPI API, which is a common starting point for extracting data. For a complete overview of the API and to access different endpoints, you can navigate through the API Reference section of the documentation. If you need further assistance or specific details on how to use the API with PowerBI or Looker Studio, please let me know!

i AM NOT ABLE TO FETCH

@FaresAhmed what data do you want to pull?

Total Cost, Total Minutes etc

@FaresAhmed you have to use the analytics API, you can learn more about it from here https://api.vapi.ai/api#/Analytics/AnalyticsController_getQuery