/
BI
bilflo
/
Bilflo.Api
Search skmtc…
⌘K
Docs
Sign in
Sign in
APIs
Generators
Stacks
Projects
Docs
History
Schema
Checked 6h ago · Updated 3w ago
Details
Filter operations
Clients
25
Companies
1
CompanySettings
10
CompanySignUp
3
Connect
4
ContractJobs
8
Contractors
15
CostCenters
5
CustomFields
4
Customizations
1
Dashboards
12
Diagnostics
3
DirectHires
4
EarningCodes
4
Employees
2
Entities
6
Erp2CompanyEvents
1
Erp2Lookups
9
Erp2Webhook
1
Everee
1
Exports
3
FieldMappings
4
JobAdder
1
Layouts
3
Notifications
1
OAuth
4
OvertimeRules
1
PayBillItem
2
PayBillItemDetail
2
PayCodes
5
PrismHR
8
Processors
1
Query Engine
3
post
Generates dynamic SQL based on the provided query request.
post
Executes the generated SQL and returns the data.
get
/qe/v{version}/Queries/get-tokens
Reports
1
Subscriptions
2
Transactions
7
Users
16
Webhook
2
Workflows
41
Query Engine
Generates dynamic SQL based on the provided query request.
post
/qe/v{version}/Queries/dynamic-sql
Path parameters
version
string
required
Headers
company-id
string
required
Request body
QueryEngineContractsModelsDtoDynamicQueryRequest
required
userId
integer
workflowEntityId
integer
primaryKey
string
nullable
fields
QueryEngineContractsModelsDtoQueryField[]
nullable
filters
QueryEngineContractsModelsDtoQueryFilter[]
nullable
sortBy
QueryEngineContractsModelsDtoQuerySort[]
nullable
groupBy
QueryEngineContractsModelsDtoQueryGroupBy[]
nullable
pagination
QueryEngineContractsModelsDtoQueryPagination
Response
Success
string
required
Changes