API - Certification Programs | Wisefish API

Overview

The list page that contains the certification programs.

Endpoint name	`certificationPrograms`
Source table	`WiFi Cert. Program Register`
Fixed view	No filter
Requests allowed	GET
Primary key	`"Source Type", "Source No.", "Customer Ship-to Code", "CP Code", "Valid until Date"`
Record ID	`systemId`
Procedures	None

Data

Field List

	Property	Type	Format	Description
1	`systemId`	string	uuid	SystemId	Record ID non-editable
2	`cpCode`	string	max 10	Certification Program Code	primary key
3	`description`	string	max 50	Description
4	`validFromDate`	string	date	Valid from Date
5	`validUntilDate`	string	date	Valid until Date	primary key
6	`customerShipToCode`	string	max 10	Customer Ship-to Code	primary key
7	`displayInInvoice`	boolean		Display In Report
8	`licenseNo`	string	max 20	License No.
9	`purchasesCertified`	string	enum	Options: Always, Sometimes
10	`sourceType`	string	enum	Options: Customer, Vendor, Stock Center, Item	primary key
11	`sourceNo`	string	max 20	Source No.	primary key
12	`type`	string	enum	Options: `MSC, IRF, ASC, AQIS`
13	`systemRowVersion`	integer		System row version. Increments every time the record is modified.	non-editable
14	`lastModified`	string	date-time	SystemModifiedAt	non-editable

Object Example

JSON

{
    "systemId": "8887ab34-1c67-f011-b024-d4cd9a9e2763", 
    "sourceType": "Item",
    "sourceNo": "70070",
    "cpCode": "SSS",
    "description": "",
    "validFromDate": "0001-01-01",
    "validUntilDate": "2026-12-31",
    "customerShipToCode": "",
    "displayInInvoice": false,
    "licenseNo": "",
    "purchasesCertified": "Always",
    "type": "ASC",
    "systemRowVersion": 2580112,
    "lastModified": "2025-07-22T16:52:09.89Z"
}

Examples

Read certification programs

Read all certification programs

Reads all certification programs, for all source types. The response is a list of certification program objects, as shown in Object Example.

JSON

GET .../certificationPrograms

Read one certification program

The Record ID is the systemId, so one certification program is read with a GET request on the following format:

JSON

GET .../certificationPrograms(8887ab34-1c67-f011-b024-d4cd9a9e2763)

Read the certification programs of an item

Reads the certification programs registered on item 70070, and returns only a few fields with $select.

Request:

JSON

GET .../certificationPrograms?$filter=sourceType eq 'Item' and sourceNo eq '70070'&$select=cpCode,type,validFromDate,validUntilDate

Response:

JSON

{
    "@odata.context": "https://containers.wisefish.com/BC/api/wisefish/base/v1.0/$metadata#companies(cf9f7b85-dd11-ef11-9f8b-6045bde9cc61)/certificationPrograms(cpCode,type,validFromDate,validUntilDate)",
    "value": [
        {
            "@odata.etag": "W/\"JzE5OzMzODEyNzQ2NTkxMDIzNDU2NzgxOzAwOyc=\"",
            "cpCode": "SSS",
            "type": "ASC",
            "validFromDate": "0001-01-01",
            "validUntilDate": "2026-12-31"
        }
    ]
}

Read certification programs that are still valid

Reads the certification programs of all vendors that are valid until 2026-01-01 or later. Date values are given without quotes in $filter. The response is a list of certification program objects.

JSON

GET .../certificationPrograms?$filter=sourceType eq 'Vendor' and validUntilDate ge 2026-01-01