Lookup List Item

Best practise

How to successfully harvest data using this endpoint:

1. Fetch locally stored lastReplicationTimestamp if applicaple

2. Call max endpoint and store MaxTimestamp.

3. Call updates endpoint with parameters: from = lastReplicationTimestamp, to = MaxTimestamp (and lastoffsetid = nextoffsetid from previous batch)

4. Call softdeletes endpoint with the same parameters as above. Before deleting locally, ensure that the deleted entity has the highest timestamp

5. Call harddeletes endpoint with the same parameters as above. Before deleting locally, ensure that the deleted entity has the highest timestamp

6. Save the stored value from step 2 (MaxTimestamp) as the new lastReplicationTimestamp

Max

This returns the max timestamp for a specific entity in order to know if there are relevant changes.

?> It is possible the reported max timestamp is irrelevant for the client/consumer (i.e. when using a filter with the related endpoints), in which case it would simply trigger an update routine with no changes.

URL : /:organizationid/:wsmid/api/v1/lookuplistitem/max

URL Parameters: organizationid=[string] is the ID of the chainbox.io organization.

wsmid=[string] is the APP ID of the WSM application.

Method: GET

Auth required: YES

Permissions required: Basic Auth credentials to the api can be delivered by contacting our support.

Success Response

Condition: If Organization & WSM app exists and the given credentials are correct.

Code: 200 OK

Content example

{
  "offset": "2021-12-01T08:20:16.421Z"
}

Error Responses

Condition: If basic auth header is not present in request or is incorrect.

Code: 401 UNAUTHORIZED

Updates

URL : /:organizationid/:wsmid/api/v1/lookuplistitem/:service/updates

URL Parameters: organizationid=[string] is the ID of the chainbox.io organization.

wsmid=[string] is the APP ID of the WSM application.

service=[string] is the name of the Service Endpoint registered in the WSM application settings. Supplying "default" as the service requires no endpoint configuration and will not apply a filter to the result.

Querystring parameters:

to=[date] returns items with a lastupdated value less than or equal to this date.

(optional) from=[date] returns items with a lastupdated value greater than this date. No default value - not supplying a value will omit this condition.

(optional) lastoffsetid=[string] returns items with a documentid greater than this value. This can be used to page through results as the items are sorted by documentid internally. No default value - not supplying a value will omit this condition.

(optional) limit=[int] number of items returned. Default = 1000.

Method: GET

Auth required: YES

Permissions required: Basic Auth credentials to the api can be delivered by contacting our support.

Success Response

Condition: If Organization & WSM app exists and the given credentials are correct.

Code: 200 OK

Content example

{
  "result": [
    {
      "createDate": "2021-08-06T14:53:14.961Z",
      "createdBy": "John Doe",
      "data": {
        "code": "xxl",
        "label": "XXL",
        "sortorder": 108,
        "lookuplist": "size",
        "fields": {},
        "identifier": "size_xxl"
      },
      "id": "size_xxl",
      "lastUpdated": "2021-08-06T14:53:14.961Z",
      "type": "pim-lookup-list-items"
    }
  ],
  "nextoffsetid": "size_xxl"
}

Error Responses

Condition: If basic auth header is not present in request or is incorrect. Code: 401 UNAUTHORIZED

Condition: Referencing an invalid service parameter. Code: 404 NOT FOUND

Soft deletes

Soft deletes are documents from the same collection not matching the service filter. If there is no active filter (e.g. using the "default" service) - an empty result will be returned.

URL : /:organizationid/:wsmid/api/v1/lookuplistitem/:service/softdeletes

URL Parameters: organizationid=[string] is the ID of the chainbox.io organization.

wsmid=[string] is the APP ID of the WSM application.

service=[string] is the name of the Service Endpoint registered in the WSM application settings. Supplying "default" as the service requires no endpoint configuration and will not apply a filter to the result.

Querystring parameters:

to=[date] returns items with a lastupdated value less than or equal to this date.

(optional) from=[date] returns items with a lastupdated value greater than this date. No default value - not supplying a value will omit this condition.

(optional) lastoffsetid=[string] returns items with a documentid greater than this value. This can be used to page through results as the items are sorted by documentid internally. No default value - not supplying a value will omit this condition.

(optional) limit=[int] number of items returned. Default = 1000.

Method: GET

Auth required: YES

Permissions required: Basic Auth credentials to the api can be delivered by contacting our support.

Success Response

Condition: If Organization & WSM app exists and the given credentials are correct.

Code: 200 OK

Content example

{
  "result": [
    {
      "id": "size_m",
      "lastUpdated": "2021-07-09T07:42:50.445Z"
    },
    {
      "id": "size_s",
      "lastUpdated": "2021-05-05T08:52:41.7Z"
    }
  ],
  "nextoffsetid": "size_s"
}

Error Responses

Condition: If basic auth header is not present in request or is incorrect. Code: 401 UNAUTHORIZED

Condition: Referencing an invalid service parameter. Code: 404 NOT FOUND

Hard deletes

Hard deletes are documents no longer in the collection.

?> It is possible the returned items are irrelevant for the client/consumer (i.e. when using a filter with the related endpoints). Match with existing IDs when appropriate.

URL : /:organizationid/:wsmid/api/v1/lookuplistitem/harddeletes

URL Parameters: organizationid=[string] is the ID of the chainbox.io organization.

wsmid=[string] is the APP ID of the WSM application.

Querystring parameters:

to=[date] returns items with a lastupdated value less than or equal to this date.

(optional) from=[date] returns items with a lastupdated value greater than this date. No default value - not supplying a value will omit this condition.

(optional) lastoffsetid=[string] returns items with a documentid greater than this value. This can be used to page through results as the items are sorted by documentid internally. No default value - not supplying a value will omit this condition.

?> Note that documentid and item id do not match. Only supply values provided by the endpoint though nextoffsetid.

(optional) limit=[int] number of items returned. Default = 1000.

Method: GET

Auth required: YES

Permissions required: Basic Auth credentials to the api can be delivered by contacting our support.

Success Response

Condition: If Organization & WSM app exists and the given credentials are correct.

Code: 200 OK

Content example

{
  "result": [
    {
      "id": "size_l",
      "lastUpdated": "2021-12-06T09:40:08.499Z"
    }
  ],
  "nextoffsetid": "61adda78880433063295a467"
}

Error Responses

Condition: If basic auth header is not present in request or is incorrect.

Code: 401 UNAUTHORIZED