Products Import from Sunsky-online in my Onlineshop

My dealer offers an Api interface with which you can import the products. Unfortunately I do not know how this works or how to program it. So I have all categories and articles in my shop. Who knows this?

Common Calling Convention

1. API End Point:

[login to view URL]

API URL sample: [login to view URL]![login to view URL]

2. Common Parameters:

key: The api key you got from SUNSKY Open API Platform.

signature: The signature for the parameters, it is generated with the parameter values and the secret you got from SUNSKY Open API Platform.

Attention: The parameters should be sorted by the name before the signature generation.

3. Result Format

The return value is formatted in JSON.

(a) Successful Result Example:

{ result: "success", data: [{"id":1032,"code":"003","gmtCreated":"01/31/2013 00:00","name":"N Style Phone","parentId":408,"status":1}] }

(b) Failed Result Example:

{ result: "error", messages: [ "The record you visiting does NOT exist." ] }

4. Call Frequency Control

SUNSKY will limit the API call frequency in case the mass calls overwhelm the servers.

Please refer this to get the frequency control info: [login to view URL]![login to view URL]

Attention: All the parameters and return values are case sensitive.

Interface 1: Get children of the category specified in the parameters

(a) URL: /openapi/category![login to view URL]

(b) Parameters:

If you don't pass any parameter, this API will retur all of the categories.

You can specify the parameters below to filter the categories you want to fetch:

* parentId: The ID of the category, which you want to get its direct child categories, optional;

* gmtModifiedStart: To fetch the categories ever changed since 'gmtModifiedStart', in the format of MM/dd/yyyy HH:mm:ss(i.e. 10/31/2013 01:23:20), optional;

(c) Result:

Summary:

* If you don't pass the parentId parameter, then an array of the all categories is returned;

* If you specify '0' for the parentId, then an array of the top categories is returned;

* If you specify other number for the parentId, then an array of the direct child categories is returned;

* If you specify a date for the gmtModifiedStart, then an array of the categories ever changed since 'gmtModifiedStart' is returned;

Fields:

* id: The unique ID of the category;

* code: The code of the category. The children of the category are sorted by code;

* name: The full name of the category;

* shortName: The short name of the category, could be empty;

* hsCode: The HS code for the products in the category, could be empty. If the HS code is empty, please check the HS code of the parent category;

* status: The status of the category. See Appendix A;

* parentId The ID of the parent category;

* gmtModified: The change time, in format of MM/dd/yyyy HH:mm:ss (i.e. 10/31/2013 01:23:20);

Hint: How to get the changed categories?

(1) Before calling the getChildren API, load the previously saved time T0 from db/file;

(2) Call the getChildren API with gmtModifiedStart=T0, it'll return the categories that ever changed since T0;

(3) Update your local db with the category data returned by the getChildren API;

(4) Update T0 to the max gmtModified among the catetories returned by the getChildren API, then save T0 to db/file;

(5) Increase the page number and repeat step 2~4 until the getChildren API returns no data;

Programare C# JSON PHP Arhitectură software XML

ID Proiect: #17416120

Detalii despre proiect