| Function: getArticles | |
| Description: get a list of products data WITHOUT IMAGE DATA itself. Use SOAP method getImage to get the image data. | |
| Request | |
| user | xsd:string |
| pass | xsd:string |
| offset | xsd:string |
| blocksize | xsd:string |
| filter | tns:arrayOfString |
| indivFieldsList | tns:indivFieldsList |
{
"function":"getArticles",
"paras":{
"user":"",
"pass":"",
"offset":"",
"blocksize":"",
"filter":[], | |
| Response | |
| result | tns:getArticlesResultItem |
{
"result":{
"productsItemExportList":[{
"products_id":0,
"external_id":"",
"permission_id":0,
"products_owner":0,
"products_ean":"",
"products_quantity":0,
"products_average_quantity":0,
"products_shippingtime":0,
"products_model":"",
"price_flag_graduated_all":0,
"price_flag_graduated_1":0,
"price_flag_graduated_2":0,
"price_flag_graduated_3":0,
"products_sort":0,
"products_option_master_price":"",
"ekomi_allow":0,
"products_image":"",
"products_price":0,
"date_added":"0001-01-01T00:00:00",
"last_modified":"0001-01-01T00:00:00",
"date_available":"0001-01-01T00:00:00",
"products_weight":0,
"products_status":0,
"products_tax_class_id":0,
"product_template":"",
"product_list_template":"",
"manufacturers_id":0,
"products_ordered":0,
"products_fsk18":0,
"products_vpe":0,
"products_vpe_status":0,
"products_vpe_value":0,
"products_startpage":0,
"products_startpage_sort":0,
"products_average_rating":0,
"products_rating_count":0,
"products_digital":0,
"flag_has_specials":0,
"products_serials":0,
"products_master_flag":"",
"products_master_model":"",
"products_keywords":{
"de":"",
"en":""
},
"products_description":{
"de":"",
"en":""
},
"products_short_description":{
"de":"",
"en":""
},
"meta_description":{
"de":"",
"en":""
},
"meta_title":{
"de":"",
"en":""
},
"meta_keywords":{
"de":"",
"en":""
},
"seo_url":{
"de":"",
"en":""
},
"url":{
"de":"",
"en":""
},
"products_special_prices":[{
"special_price":0,
"status":0,
"date_available":"0001-01-01T00:00:00",
"date_expired":"0001-01-01T00:00:00",
"group_permissions":[],
"group_permission_all":0
} ],
"products_name":{
"de":"",
"en":""
},
"categories":[],
"image_name":"",
"image":"",
"products_prices":[{
"price":0,
"staffel":0,
"group":"",
"quantity":0
} ],
"products_cross_sell":[],
"products_images":[{
"type":"",
"id":"",
"image_name":"",
"image_data":""
} ],
"products_categories":[],
"products_attributes":[{
"attributes_id":0,
"attributes_parent_id":0
} ],
"permissionList":[{
"external_id":"",
"permission":true,
"pgroup":""
} ],
"indivFieldsList":[{
"dstTable":"",
"sqlFieldName":"",
"sqlFieldType":"",
"value":"",
"langValue":{
"de":"",
"en":""
}
} ],
"products_media_urlList":[{
"type":"",
"file":"",
"width":"",
"height":"",
"folder":"",
"url":""
} ]
} ],
"result":true,
"message":""
}
} | |
Hinweis: Die Parameter 'offset' und 'blocksize' dienen zur Navigation durch die Treffermenge analog zu SQL "START" und "LIMIT". So kann eine große Treffermenge auf Teilblöcke reduziert werden, was zu erheblichen Performancegewinnen führen kann.
Hinweis: Der Parameter 'filter' kann verwendet werden um auf einzelne oder mehrere Artikel zu selektieren. Es können derzeit alle Felder innerhalb der Tabelle 'TABLE_PRODUCTS' abgefragt werden.
Beispiele:
Abfrage aller Artikel mit Lagerbestand = 0
{
"function": "getArticles",
"paras": {
"user": "{{api_user}}",
"pass": "{{api_password}}",
"offset":"0",
"blocksize":"50",
"filter":["products_quantity=0"],
"indivFieldList":[]
}
}
