- BOMs
- Gets Boms that user has read access toGET
- Creates a Bom using Cofactr DataPOST
- Creates a Bom using raw bomline data and performs searches to convert into Cofactr DataPOST
- Gets a BomGET
- Upsert BOM AsyncPUT
- Updates a BomPATCH
- Deletes a Bom if still unapproved. Archives a bom if approved.DELETE
- Approves an unapproved Bom.POST
- Gets Bom Lines on a Bom.GET
- Creates a new bomline on a Bom using Cofactr data. If a bomline with the provided part exists it will sum the quants instead of duplicating lines.POST
- Gets a BomLineGET
- Updates a BomLinePATCH
- Removes a Bomline from a Bom.DELETE
- Attempts to create a new Bomline using raw data and performs searches to convert into Cofactr Data. If a Bomline with the same part and refdes exists it will sum the quants instead of duplicating lines.POST
- Programs
- Gets ProgramsGET
- Creates a ProgramPOST
- Gets a ProgramGET
- Updates a ProgramPATCH
- Deletes a ProgramDELETE
- Gets Program AvailabilitiesGET
- Gets Program Availabilities AsyncGET
- Gets Program Reference PricingGET
- Get Programs LinesGET
- Get Programs LineGET
- Update Programs LinePATCH
- Delete Programs LineDELETE
- Create Programs LinesPOST
- Get Program Part OverridesGET
- Create Program Part OverridesPOST
- Get Program Part OverrideGET
- Update Program Part OverridePATCH
- Delete Program Part OverrideDELETE
- Account
- Reporting
- Email
- Auth
- Async Jobs
- Stock Documents
- Suppliers
- Parts
- Purchases
- Get Purchase Order
- Create Purchase Order
- Update Purchase Order
- Delete Purchase Order
- Get Purchase Lines
- Get Purchase Line
- Create Purchase Line
- Update Many Purchase Lines
- Delete Purchase Line
- Get NoPart Purchase Lines
- Create NoPart Purchase Line
- Update Many NoPart Purchase Lines
- Delete NoPart Purchase Line
- Create Purchase Event
- Update Supplier Bill
- Update Supplier Bill Line
- Create Supplier Bill
- Create Supplier Bill Line
- Teams
- Custom Properties
- Stock Lots
- Tags
- Rfqs
- RfqLines
- SupplierQuote
- SupplierQuoteLines
Customer SQL Query
POST
/integration_reporting/query/
Request
Authorization
Add parameter in header
Authorization
Example:
Authorization: ********************Query Params
blended
string
optional
Request samples
Shell
JavaScript
Java
Swift
Go
PHP
Python
HTTP
C
C#
Objective-C
Ruby
OCaml
Dart
R
Request Request Example
Shell
JavaScript
Java
Swift
curl --location --request POST '/integration_reporting/query/?blended' \
--header 'Authorization;'Responses
🟢200Success
application/json
Body
length
integer
Length
columns
array[object (ReportingSchemaColumn) {2}]
required
name
string
Name
>= 1 characters
type
string
Type
>= 1 characters
data
array [object {1}]
required
Additional properties
string
optional
>= 1 characters
Example
{
"length": 0,
"columns": [
{
"name": "string",
"type": "string"
}
],
"data": [
{
"property1": "string",
"property2": "string"
}
]
}Modified at 2024-09-13 01:14:33