Business Central queries
Pages with PageType API and queries with QueryType API, with the publisher, group, version and entity set they declare.
98 queries
| query 5480 "Customer Sales Entity" | Base Application | 17-29 |
| Entity set customerSales | ||
| query 5481 "Vendor Purchases Entity" | Base Application | 17-29 |
| Entity set vendorPurchases | ||
| query 6210 "Country Region - PBI API" | Sustainability | new in 27 |
| Publisher/group/version microsoft/analytics/'v0.5', 'v1.0'Entity set pbiCountryRegions | ||
| query 6211 "Emission Fees - PBI API" | Sustainability | new in 27 |
| Publisher/group/version microsoft/analytics/'v0.5', 'v1.0'Entity set pbiEmissionFees | ||
| query 6212 "Employee Absence - PBI API" | Sustainability | new in 27 |
| Publisher/group/version microsoft/analytics/'v0.5', 'v1.0'Entity set pbiEmployeeAbsences | ||
| query 6213 "Employee | Sustainability | new in 27 |
| Publisher/group/version microsoft/analytics/'v0.5', 'v1.0'Entity set pbiEmployeeLedgerEntries | ||
| query 6214 "Employee Quali - PBI API" | Sustainability | new in 27 |
| Publisher/group/version microsoft/analytics/'v0.5', 'v1.0'Entity set pbiEmployeeQualifications | ||
| query 6215 "Employees - PBI API" | Sustainability | new in 27 |
| Publisher/group/version microsoft/analytics/'v0.5', 'v1.0'Entity set pbiEmployees | ||
| query 6216 "Resp Centre - PBI API" | Sustainability | new in 27 |
| Publisher/group/version microsoft/analytics/'v0.5', 'v1.0'Entity set pbiResponsibilityCentres | ||
| query 6217 "Sus | Sustainability | new in 27 |
| Publisher/group/version microsoft/analytics/'v0.5', 'v1.0'Entity set pbiSustainabilitySubAccountCategories | ||
| query 6218 "Sust Account Cat - PBI API" | Sustainability | new in 27 |
| Publisher/group/version microsoft/analytics/'v0.5', 'v1.0'Entity set pbiSustainabilityAccountCategories | ||
| query 6219 "Sust Accounts - PBI API" | Sustainability | new in 27 |
| Publisher/group/version microsoft/analytics/'v0.5', 'v1.0'Entity set pbiSustainabilityAccounts | ||
| query 6220 "Sustainability Goals - PBI API" | Sustainability | new in 27 |
| Publisher/group/version microsoft/analytics/'v0.5', 'v1.0'Entity set pbiSustainabilityGoals | ||
| query 6221 "Sust Ledger Entries - PBI API" | Sustainability | new in 27 |
| Publisher/group/version microsoft/analytics/'v0.5', 'v1.0'Entity set pbiSustainabilityLedgerEntries | ||
| query 20401 "Qlty. Inspection Values" | Quality Management | new in 28 |
| Publisher/group/version microsoft/qualityManagement/'v1.0'Entity set qualityInspectionValues | ||
| query 36950 "Power | PowerBI Reports | 25 to 26 |
| Publisher/group/version microsoft/analytics/'v0.5'Entity set dimensionSetEntries | ||
| query 36952 Dimensions | PowerBI Reports | 25 to 26 |
| Publisher/group/version microsoft/analytics/'v0.5'Entity set dimensions | ||
| query 36953 "Items - PBI API" | PowerBI Reports | 25 to 26 |
| Publisher/group/version microsoft/analytics/'v0.5'Entity set items | ||
| query 36954 "Account Categories" | PowerBI Reports | 25 to 26 |
| Publisher/group/version microsoft/analytics/'v0.5'Entity set accountCategories | ||
| query 36955 "G\L Entries - Balance Sheet" | PowerBI Reports | 25 to 26 |
| Publisher/group/version microsoft/analytics/'v0.5'Entity set balanceSheetGeneralLedgerEntries | ||
| query 36956 "G/L Entries - Closing" | PowerBI Reports | 25 to 26 |
| Publisher/group/version microsoft/analytics/'v0.5'Entity set closingGeneralLedgerEntries | ||
| query 36957 "Customer Ledger Entries" | PowerBI Reports | 25 to 26 |
| Publisher/group/version microsoft/analytics/'v0.5'Entity set customerLedgerEntries | ||
| query 36958 "G/L Account Categories" | PowerBI Reports | 25 to 26 |
| Publisher/group/version microsoft/analytics/'v0.5'Entity set generalLedgerAccountCategories | ||
| query 36959 "G/L Accounts" | PowerBI Reports | 25 to 26 |
| Publisher/group/version microsoft/analytics/'v0.5'Entity set generalLedgerAccounts | ||
| query 36960 "G/L Budget Entries - PBI API" | PowerBI Reports | 25 to 26 |
| Publisher/group/version microsoft/analytics/'v0.5'Entity set generalLedgerBudgetEntries | ||
| query 36961 "G/L Budgets" | PowerBI Reports | 25 to 26 |
| Publisher/group/version microsoft/analytics/'v0.5'Entity set generalLedgerBudgets | ||
| query 36962 "G/L Entries - Income Statement" | PowerBI Reports | 25 to 26 |
| Publisher/group/version microsoft/analytics/'v0.5'Entity set incomeStatementGeneralLedgerEntries | ||
| query 36963 "Vendor Ledg. Entries - PBI API" | PowerBI Reports | 25 to 26 |
| Publisher/group/version microsoft/analytics/'v0.5'Entity set vendorLedgerEntries | ||
| query 36964 "Assembly Headers - Order" | PowerBI Reports | 25 to 26 |
| Publisher/group/version microsoft/analytics/'v0.5'Entity set assemblyHeaders | ||
| query 36965 "Assembly Lines - Item" | PowerBI Reports | 25 to 26 |
| Publisher/group/version microsoft/analytics/'v0.5'Entity set assemblyLines | ||
| query 36966 Bins | PowerBI Reports | 25 to 26 |
| Publisher/group/version microsoft/analytics/'v0.5'Entity set bins | ||
| query 36967 "Value Entries - Item" | PowerBI Reports | 25 to 26 |
| Publisher/group/version microsoft/analytics/'v0.5'Entity set itemValueEntries | ||
| query 36968 "Item Ledger Entries - PBI API" | PowerBI Reports | 25 to 26 |
| Publisher/group/version microsoft/analytics/'v0.5'Entity set itemLedgerEntries | ||
| query 36969 "Job Planning Lines - Item" | PowerBI Reports | 25 to 26 |
| Publisher/group/version microsoft/analytics/'v0.5'Entity set itemJobPlanningLines | ||
| query 36970 "Planning Components" | PowerBI Reports | 25 to 26 |
| Publisher/group/version microsoft/analytics/'v0.5'Entity set planningComponentLines | ||
| query 36971 "Prod. Order Comp. - Invt." | PowerBI Reports | 25 to 26 |
| Publisher/group/version microsoft/analytics/'v0.5'Entity set inventoryProdOrderComponentLines | ||
| query 36972 "Prod. Order Lines - Invt." | PowerBI Reports | 25 to 26 |
| Publisher/group/version microsoft/analytics/'v0.5'Entity set inventoryProdOrderLines | ||
| query 36973 "Purchase Lines - Outstanding" | PowerBI Reports | 25 to 26 |
| Publisher/group/version microsoft/analytics/'v0.5'Entity set outstandingPurchaseLines | ||
| query 36974 "Requisition Lines" | PowerBI Reports | 25 to 26 |
| Publisher/group/version microsoft/analytics/'v0.5'Entity set requisitionLines | ||
| query 36975 "Sales Lines - Outstanding" | PowerBI Reports | 25 to 26 |
| Publisher/group/version microsoft/analytics/'v0.5'Entity set outstandingSalesLines | ||
| query 36976 "Service Lines - Order" | PowerBI Reports | 25 to 26 |
| Publisher/group/version microsoft/analytics/'v0.5'Entity set orderServiceLines | ||
| query 36977 "Transfer Lines" | PowerBI Reports | 25 to 26 |
| Publisher/group/version microsoft/analytics/'v0.5'Entity set transferLines | ||
| query 36978 "Warehouse Activity Lines" | PowerBI Reports | 25 to 26 |
| Publisher/group/version microsoft/analytics/'v0.5'Entity set warehouseActivityLines | ||
| query 36979 "Warehouse Entries" | PowerBI Reports | 25 to 26 |
| Publisher/group/version microsoft/analytics/'v0.5'Entity set warehouseEntries | ||
| query 36980 "Whse. Journal Lines - From Bin" | PowerBI Reports | 25 to 26 |
| Publisher/group/version microsoft/analytics/'v0.5'Entity set fromBinWarehouseJournalLines | ||
| query 36981 "Whse. Journal Lines - To Bin" | PowerBI Reports | 25 to 26 |
| Publisher/group/version microsoft/analytics/'v0.5'Entity set toBinWarehouseJournalLines | ||
| query 36982 Zones | PowerBI Reports | 25 to 26 |
| Publisher/group/version microsoft/analytics/'v0.5'Entity set zones | ||
| query 36983 "Calendar Entries" | PowerBI Reports | 25 to 26 |
| Publisher/group/version microsoft/analytics/'v0.5'Entity set calendarEntries | ||
| query 36984 "Capacity Ledger Entries" | PowerBI Reports | 25 to 26 |
| Publisher/group/version microsoft/analytics/'v0.5'Entity set capacityLedgerEntries | ||
| query 36985 "Machine Centers" | PowerBI Reports | 25 to 26 |
| Publisher/group/version microsoft/analytics/'v0.5'Entity set machineCenters | ||
| query 36986 "Item Ledger Entries - Prod." | PowerBI Reports | 25 to 26 |
| Publisher/group/version microsoft/analytics/'v0.5'Entity set prodItemLedgerEntries | ||
| query 36987 "Prod. Order Capacity Needs" | PowerBI Reports | 25 to 26 |
| Publisher/group/version microsoft/analytics/'v0.5'Entity set prodOrderCapacityNeeds | ||
| query 36988 "Prod. Order Comp. - Manuf." | PowerBI Reports | 25 to 26 |
| Publisher/group/version microsoft/analytics/'v0.5'Entity set manufacturingProdOrderComponents | ||
| query 36989 "Prod. Order Lines - Manuf." | PowerBI Reports | 25 to 26 |
| Publisher/group/version microsoft/analytics/'v0.5'Entity set manufacturingProdOrderLines | ||
| query 36990 "Prod. Order Routing Lines" | PowerBI Reports | 25 to 26 |
| Publisher/group/version microsoft/analytics/'v0.5'Entity set prodOrderRoutingLines | ||
| query 36991 "Work Centers" | PowerBI Reports | 25 to 26 |
| Publisher/group/version microsoft/analytics/'v0.5'Entity set workCenters | ||
| query 36992 "Job Ledger Entries - PBI API" | PowerBI Reports | 25 to 26 |
| Publisher/group/version microsoft/analytics/'v0.5'Entity set jobLedgerEntries | ||
| query 36993 "Job Planning Lines" | PowerBI Reports | 25 to 26 |
| Publisher/group/version microsoft/analytics/'v0.5'Entity set jobPlanningLines | ||
| query 36994 "Job Tasks" | PowerBI Reports | 25 to 26 |
| Publisher/group/version microsoft/analytics/'v0.5'Entity set jobTasks | ||
| query 36995 Jobs | PowerBI Reports | 25 to 26 |
| Publisher/group/version microsoft/analytics/'v0.5'Entity set jobs | ||
| query 36996 "Purch. Lines - Job Outstanding" | PowerBI Reports | 25 to 26 |
| Publisher/group/version microsoft/analytics/'v0.5'Entity set jobOutstandingPurchaseLines | ||
| query 36997 "Purch. Lines - Job Received" | PowerBI Reports | 25 to 26 |
| Publisher/group/version microsoft/analytics/'v0.5'Entity set jobReceivedNotInvoicedPurchaseLines | ||
| query 36998 "Purch. Lines - Item Outstd." | PowerBI Reports | 25 to 26 |
| Publisher/group/version microsoft/analytics/'v0.5'Entity set itemOutstandingPurchaseLines | ||
| query 36999 "Item Budget Entries - Purch." | PowerBI Reports | 25 to 26 |
| Publisher/group/version microsoft/analytics/'v0.5'Entity set purchaseItemBudgetEntries | ||
| query 37000 "Value Entries - Purch." | PowerBI Reports | 25 to 26 |
| Publisher/group/version microsoft/analytics/'v0.5'Entity set purchaseValueEntries | ||
| query 37001 "Purch. Lines - Item Received" | PowerBI Reports | 25 to 26 |
| Publisher/group/version microsoft/analytics/'v0.5'Entity set itemReceivedNotInvoicedPurchaseLines | ||
| query 37002 "Item Budget Names" | PowerBI Reports | 25 to 26 |
| Publisher/group/version microsoft/analytics/'v0.5'Entity set itemBudgets | ||
| query 37003 "Sales Line - Item Outstanding" | PowerBI Reports | 25 to 26 |
| Publisher/group/version microsoft/analytics/'v0.5'Entity set itemOutstandingSalesLines | ||
| query 37004 "Item Budget Entries - Sales" | PowerBI Reports | 25 to 26 |
| Publisher/group/version microsoft/analytics/'v0.5'Entity set salesItemBudgetEntries | ||
| query 37005 "Value Entries - Sales" | PowerBI Reports | 25 to 26 |
| Publisher/group/version microsoft/analytics/'v0.5'Entity set salesValueEntries | ||
| query 37006 "Sales Line - Item Shipped" | PowerBI Reports | 25 to 26 |
| Publisher/group/version microsoft/analytics/'v0.5'Entity set itemShippedNotInvoicedSalesLines | ||
| query 37007 "Manufacturing Setup - PBI API" | PowerBI Reports | 26 to 26 |
| Publisher/group/version microsoft/analytics/'v0.5'Entity set manufacturingSetup | ||
| query 37008 "Prod. Orders - PBI API" | PowerBI Reports | 26 to 26 |
| Publisher/group/version microsoft/analytics/'v0.5'Entity set manufacturingProductionOrders | ||
| query 37009 "Routing Links - PBI API" | PowerBI Reports | 26 to 26 |
| Publisher/group/version microsoft/analytics/'v0.5'Entity set routingLinks | ||
| query 37010 "Routings - PBI API" | PowerBI Reports | 26 to 26 |
| Publisher/group/version microsoft/analytics/'v0.5'Entity set routings | ||
| query 37011 "Manuf. Value Entries - PBI API" | PowerBI Reports | 26 to 26 |
| Publisher/group/version microsoft/analytics/'v0.5'Entity set manufacturingValueEntries | ||
| query 37012 "Work Center Groups - PBI API" | PowerBI Reports | 26 to 26 |
| Publisher/group/version microsoft/analytics/'v0.5'Entity set workCenterGroups | ||
| query 37013 "Close Income Source - PBI API" | PowerBI Reports | 26 to 26 |
| Publisher/group/version microsoft/analytics/'v0.5'Entity set closeIncomeStmtSourceCodes | ||
| query 37014 "G/L Income Statement - PBI API" | PowerBI Reports | 26 to 26 |
| Publisher/group/version microsoft/analytics/'v0.5'Entity set incomeStmtGeneralLedgerEntries | ||
| query 37016 "Dynamic Dimensions - PBI API" | PowerBI Reports | 26 to 26 |
| Publisher/group/version microsoft/analytics/'v0.5'Entity set dynamicDimensions | ||
| query 37017 "Opportunity - PBI API" | PowerBI Reports | 26 to 26 |
| Publisher/group/version microsoft/analytics/'v0.5'Entity set opportunities | ||
| query 37018 "Opportunity Entries - PBI API" | PowerBI Reports | 26 to 26 |
| Publisher/group/version microsoft/analytics/'v0.5'Entity set opportunityEntries | ||
| query 37019 "Sales Line - PBI API" | PowerBI Reports | 26 to 26 |
| Publisher/group/version microsoft/analytics/'v0.5'Entity set salesLines | ||
| query 37020 "Inv. Adj. Ent Order - PBI API" | PowerBI Reports | 26 to 26 |
| Publisher/group/version microsoft/analytics/'v0.5'Entity set inventoryAdjustmentEntryOrders | ||
| query 37021 "Sustainability Goals - PBI API" | PowerBI Reports | 26 to 26 |
| Publisher/group/version microsoft/analytics/'v0.5'Entity set pbiSustainabilityGoals | ||
| query 37022 "Sust Ledger Entries - PBI API" | PowerBI Reports | 26 to 26 |
| Publisher/group/version microsoft/analytics/'v0.5'Entity set pbiSustainabilityLedgerEntries | ||
| query 37060 "Employee Quali - PBI API" | PowerBI Reports | 26 to 26 |
| Publisher/group/version microsoft/analytics/'v0.5'Entity set pbiEmployeeQualifications | ||
| query 37061 "Employees - PBI API" | PowerBI Reports | 26 to 26 |
| Publisher/group/version microsoft/analytics/'v0.5'Entity set pbiEmployees | ||
| query 37062 "Country Region - PBI API" | PowerBI Reports | 26 to 26 |
| Publisher/group/version microsoft/analytics/'v0.5'Entity set pbiCountryRegions | ||
| query 37063 "Emission Fees - PBI API" | PowerBI Reports | 26 to 26 |
| Publisher/group/version microsoft/analytics/'v0.5'Entity set pbiEmissionFees | ||
| query 37064 "Employee Absence - PBI API" | PowerBI Reports | 26 to 26 |
| Publisher/group/version microsoft/analytics/'v0.5'Entity set pbiEmployeeAbsences | ||
| query 37065 "Employee | PowerBI Reports | 26 to 26 |
| Publisher/group/version microsoft/analytics/'v0.5'Entity set pbiEmployeeLedgerEntries | ||
| query 37066 "Resp Centre - PBI API" | PowerBI Reports | 26 to 26 |
| Publisher/group/version microsoft/analytics/'v0.5'Entity set pbiResponsibilityCentres | ||
| query 37067 "Sus | PowerBI Reports | 26 to 26 |
| Publisher/group/version microsoft/analytics/'v0.5'Entity set pbiSustainabilitySubAccountCategories | ||
| query 37068 "Sust Account Cat - PBI API" | PowerBI Reports | 26 to 26 |
| Publisher/group/version microsoft/analytics/'v0.5'Entity set pbiSustainabilityAccountCategories | ||
| query 37069 "Sust Accounts - PBI API" | PowerBI Reports | 26 to 26 |
| Publisher/group/version microsoft/analytics/'v0.5'Entity set pbiSustainabilityAccounts | ||
| query 130135 "Mock API Query" | System Application Test Library | new in 28 |
| Publisher/group/version mock/mcp/'v1.0'Entity set mockQueries | ||
| query 130136 "Mock APIV2 Query" | System Application Test Library | new in 28 |
| Publisher/group/version 'v2.0'Entity set mockV2Queries | ||