Material Substance
The material substance resource.
Base/materialSubstance
GET
/materialSubstanceList material substances
Retrieve a paginated list of material substances. Filter, order, and select columns with PostgREST query parameters.
Query parameters
selectstringComma-separated columns to return. Defaults to all.
orderstringColumn to sort by, e.g. `createdAt.desc`.
limitintegerMaximum rows to return.
offsetintegerRows to skip, for pagination.
GET/materialSubstance
curl --request GET \
--url '<your-host>/materialSubstance?select=*&limit=10' \
--header 'Authorization: Bearer <api-key>'Response
[
{
"id": "abc123def456",
"name": "Example",
"createdBy": "string",
"createdAt": "2026-01-01T00:00:00Z",
"code": "string",
"companyId": "xyz789",
"customFields": "string",
"updatedBy": "string"
}
]GET
/materialSubstanceRetrieve a material substance
Fetch a single material substance by filtering on `id`.
Query parameters
idstringMatch on the material substance's `id`, e.g. `eq.{id}`.
GET/materialSubstance
curl --request GET \
--url '<your-host>/materialSubstance?id=eq.%7Bid%7D' \
--header 'Authorization: Bearer <api-key>'Response
{
"id": "abc123def456",
"name": "Example",
"createdBy": "string",
"createdAt": "2026-01-01T00:00:00Z",
"code": "string",
"companyId": "xyz789",
"customFields": "string",
"updatedBy": "string"
}POST
/materialSubstanceCreate a material substance
Create a new material substance.
Body parameters
namestringrequiredcompanyIdstringReferences company.id
customFieldsobjecttagsarraycodestringrequiredPOST/materialSubstance
curl --request POST \
--url <your-host>/materialSubstance \
--header 'Authorization: Bearer <api-key>' \
--header 'Content-Type: application/json' \
--header 'Prefer: return=representation' \
--data '{"name":"Example","code":"string"}'Response
{
"id": "abc123def456",
"name": "Example",
"createdBy": "string",
"createdAt": "2026-01-01T00:00:00Z",
"code": "string",
"companyId": "xyz789",
"customFields": "string",
"updatedBy": "string"
}PATCH
/materialSubstanceUpdate a material substance
Update an existing material substance, matched on `id`.
Body parameters
namestringrequiredcompanyIdstringReferences company.id
customFieldsobjecttagsarraycodestringrequiredPATCH/materialSubstance
curl --request PATCH \
--url '<your-host>/materialSubstance?id=eq.%7Bid%7D' \
--header 'Authorization: Bearer <api-key>' \
--header 'Content-Type: application/json' \
--header 'Prefer: return=representation' \
--data '{"name":"Example"}'Response
{
"id": "abc123def456",
"name": "Example",
"createdBy": "string",
"createdAt": "2026-01-01T00:00:00Z",
"code": "string",
"companyId": "xyz789",
"customFields": "string",
"updatedBy": "string"
}DELETE
/materialSubstanceDelete a material substance
Delete a material substance, matched on `id`. Returns 204 No Content.
Query parameters
idstringThe `id` of the material substance to delete, e.g. `eq.{id}`.
DELETE/materialSubstance
curl --request DELETE \
--url '<your-host>/materialSubstance?id=eq.%7Bid%7D' \
--header 'Authorization: Bearer <api-key>'204 No Content