Retrieve and analyze Dataverse records using the Python SDK and Web API.
npx skills add https://github.com/microsoft/Dataverse-skills --skill dv-query
Please help me install this Agent Skill. Skill: dv-query Source: https://github.com/microsoft/Dataverse-skills/tree/main/.github/plugins/dataverse/skills/dv-query Command: npx skills add https://github.com/microsoft/Dataverse-skills --skill dv-query
Bulk reads, multi-page iteration, and analytics across Dataverse records using the Python SDK and Web API, enabling efficient data access and analysis without manual pagination.
$expand, and $apply aggregations to answer complex questions and cross-table scenarios.client.dataframe.get() for analysis, notebooks, and export to CSV/Excel.Query records from a table using the Python SDK and load results into a pandas DataFrame.
High-intent search queries and answers about installing and using this skill.
You can query Dataverse records and load them into a pandas DataFrame using the Python SDK's client.dataframe.get() method, which handles authenticated access and efficiently hands off data for analysis.
To handle pagination when retrieving bulk Dataverse data, use the Python SDK's multi-page query capabilities, which automatically manage paging across large record sets without manual iteration logic.
Yes, you can perform cross-table queries and aggregations using the Dataverse Web API by applying server-side options like $expand for related tables and $apply for aggregations to answer complex questions.
Yes, you need the Dataverse SDK and Python environment to execute safe, authenticated server-side queries, with optional pandas required to structure returned records into DataFrames for notebook analysis.
The Dataverse Python SDK supports multi-page iteration and $apply aggregations, enabling users to retrieve bulk records and compute server-side aggregations across single-table and cross-table queries.
Using a QueryBuilder for Dataverse data analysis instead of manual API calls ensures safe authenticated access, streamlines complex server-side options, and directly structures results for DataFrame handoff.
pingqLINPerform CRUD, bulk, file, and table operations on Microsoft Dataverse via Python.
hico-mrmgnAnalyze and visualize CSV and Excel data with Python, Pandas, and Matplotlib/Seaborn.
SethyPagnaExecute Python iteratively with persistent kernel state in JupyterLab sessions.
CyapstayePerform CRUD operations on Airtable bases and records via REST API.