|
|
(JavaScript) MercadoLibre - Search Orders from a Buyer
Search for orders from a buyer. For more information, see https://developers.mercadolibre.com.ar/es_ar/gestiona-ventas#Como-filtrar
var success = false;
// This example assumes the Chilkat API to have been previously unlocked.
// See Global Unlock Sample for sample code.
var http = new CkHttp();
// First get our previously obtained OAuth2 access token.
var jsonToken = new CkJsonObject();
success = jsonToken.LoadFile("qa_data/tokens/mercadolibre.json");
// Implements the following CURL command:
// curl -X GET https://api.mercadolibre.com/orders/search?buyer=$BUYER_ID&access_token=$ACCESS_TOKEN
// Use the following online tool to generate HTTP code from a CURL command
// Convert a cURL Command to HTTP Source Code
http.SetUrlVar("access_token",jsonToken.StringOf("access_token"));
// Use an actual buyer ID here..
http.SetUrlVar("buyer_id","577815702");
var sbResponseBody = new CkStringBuilder();
success = http.QuickGetSb("https://api.mercadolibre.com/orders/search?buyer={$buyer_id}&access_token={$access_token}",sbResponseBody);
if (success == false) {
console.log(http.LastErrorText);
console.log("Response Header:");
console.log(http.LastHeader);
console.log("----");
console.log("Response Body:");
console.log(sbResponseBody.GetAsString());
console.log("Failed.");
return;
}
var jResp = new CkJsonObject();
jResp.LoadSb(sbResponseBody);
jResp.EmitCompact = false;
console.log("Response Body:");
console.log(jResp.Emit());
var respStatusCode = http.LastStatus;
console.log("Response Status Code = " + respStatusCode);
if (respStatusCode >= 400) {
console.log("Response Header:");
console.log(http.LastHeader);
console.log("----");
console.log("Response Body:");
console.log(sbResponseBody.GetAsString());
console.log("Failed.");
return;
}
// Sample JSON response:
// (Sample code for parsing the JSON response is shown below)
// {
// "query": "2032217210",
// "results": [
// {
// "seller": {
// "phone": {
// "number": "11971427863",
// "extension": "",
// "area_code": null,
// "verified": false
// },
// "alternative_phone": {
// "number": "",
// "extension": "",
// "area_code": ""
// },
// "nickname": "VENDASDKMB",
// "last_name": "Cheracomo",
// "id": 239432672,
// "first_name": "Demétrio",
// "email": "dcherac.8m6k0q+2-ogiydgmrsge3tenby@mail.mercadolivre.com"
// },
// "payments": [
// {
// "reason": "Kit Com 03 Adesivo Spray 3m 75 Cola Silk Sublimação 300g",
// "status_code": null,
// "total_paid_amount": 129.95,
// "operation_type": "regular_payment",
// "transaction_amount": 129.95,
// "date_approved": "2019-05-22T03:51:07.000-04:00",
// "collector": {
// "id": 239432672
// },
// "coupon_id": null,
// "installments": 1,
// "authorization_code": "008877",
// "taxes_amount": 0,
// "id": 4792155710,
// "date_last_modified": "2019-05-22T03:51:07.000-04:00",
// "coupon_amount": 0,
// "available_actions": [
// "refund"
// ],
// "shipping_cost": 0,
// "installment_amount": 129.95,
// "date_created": "2019-05-22T03:51:05.000-04:00",
// "activation_uri": null,
// "overpaid_amount": 0,
// "card_id": 203453778,
// "status_detail": "accredited",
// "issuer_id": "24",
// "payment_method_id": "master",
// "payment_type": "credit_card",
// "deferred_period": null,
// "atm_transfer_reference": {
// "transaction_id": "135292",
// "company_id": null
// },
// "site_id": "MLB",
// "payer_id": 89660613,
// "marketplace_fee": 14.290000000000001,
// "order_id": 2032217210,
// "currency_id": "BRL",
// "status": "approved",
// "transaction_order_id": null
// }
// ],
// "fulfilled": true,
// "buying_mode": "buy_equals_pay",
// "taxes": {
// "amount": null,
// "currency_id": null
// },
// "order_request": {
// "change": null,
// "return": null
// },
// "expiration_date": "2019-06-19T03:51:07.000-04:00",
// "feedback": {
// "sale": null,
// "purchase": null
// },
// "shipping": {
// "id": 27968238880
// },
// "date_closed": "2019-05-22T03:51:07.000-04:00",
// "id": 2032217210,
// "manufacturing_ending_date": null,
// "hidden_for_seller": false,
// "order_items": [
// {
// "item": {
// "seller_custom_field": null,
// "condition": "new",
// "category_id": "MLB33383",
// "variation_id": null,
// "variation_attributes": [
// ],
// "seller_sku": null,
// "warranty": "Garantia de 1 ano fabricante",
// "id": "MLB1054990648",
// "title": "Kit Com 03 Adesivo Spray 3m 75 Cola Silk Sublimação 300g"
// },
// "quantity": 1,
// "differential_pricing_id": null,
// "sale_fee": 14.29,
// "listing_type_id": "gold_special",
// "base_currency_id": null,
// "unit_price": 129.95,
// "full_unit_price": 129.95,
// "base_exchange_rate": null,
// "currency_id": "BRL",
// "manufacturing_days": null
// }
// ],
// "date_last_updated": "2020-02-14T02:55:49.811Z",
// "last_updated": "2019-05-28T15:16:04.000-04:00",
// "comments": null,
// "pack_id": null,
// "coupon": {
// "amount": 0,
// "id": null
// },
// "shipping_cost": 0,
// "date_created": "2019-05-22T03:51:05.000-04:00",
// "application_id": "7092",
// "pickup_id": null,
// "status_detail": null,
// "tags": [
// "delivered",
// "paid"
// ],
// "buyer": {
// "billing_info": {
// "doc_number": "02183212950",
// "doc_type": "CPF"
// },
// "phone": {
// "number": "99962663",
// "extension": "",
// "area_code": "41",
// "verified": false
// },
// "alternative_phone": {
// "number": "30576339",
// "extension": "",
// "area_code": "41"
// },
// "nickname": "S.VICTORHUGO",
// "last_name": "Schemberger",
// "id": 89660613,
// "first_name": "Victor Hugo",
// "email": "vschemb.y14cdz+2-ogiydgmrsge3tenbz@mail.mercadolivre.com"
// },
// "total_amount": 129.95,
// "paid_amount": 129.95,
// "mediations": [
// ],
// "currency_id": "BRL",
// "status": "paid"
// }
// ],
// "sort": {
// "id": "date_asc",
// "name": "Date ascending"
// },
// "available_sorts": [
// {
// "id": "date_desc",
// "name": "Date descending"
// }
// ],
// "filters": [
// ],
// "paging": {
// "total": 1,
// "offset": 0,
// "limit": 50
// },
// "display": "complete"
// }
// Sample code for parsing the JSON response...
// Use the following online tool to generate parsing code from sample JSON:
// Generate Parsing Code from JSON
var date_closed = new CkDtObj();
var date_last_updated = new CkDtObj();
var date_created = new CkDtObj();
var date_approved = new CkDtObj();
var date_last_modified = new CkDtObj();
var sellerPhoneNumber;
var sellerPhoneExtension;
var sellerPhoneArea_code;
var sellerPhoneVerified;
var sellerAlternative_phoneNumber;
var sellerAlternative_phoneExtension;
var sellerAlternative_phoneArea_code;
var sellerNickname;
var sellerLast_name;
var sellerId;
var sellerFirst_name;
var sellerEmail;
var fulfilled;
var buying_mode;
var taxesAmount;
var taxesCurrency_id;
var order_requestChange;
var order_requestReturn;
var expiration_date;
var feedbackSale;
var feedbackPurchase;
var shippingId;
var id;
var manufacturing_ending_date;
var hidden_for_seller;
var last_updated;
var comments;
var pack_id;
var couponAmount;
var couponId;
var shipping_cost;
var application_id;
var pickup_id;
var status_detail;
var buyerBilling_infoDoc_number;
var buyerBilling_infoDoc_type;
var buyerPhoneNumber;
var buyerPhoneExtension;
var buyerPhoneArea_code;
var buyerPhoneVerified;
var buyerAlternative_phoneNumber;
var buyerAlternative_phoneExtension;
var buyerAlternative_phoneArea_code;
var buyerNickname;
var buyerLast_name;
var buyerId;
var buyerFirst_name;
var buyerEmail;
var total_amount;
var paid_amount;
var currency_id;
var status;
var j;
var count_j;
var reason;
var status_code;
var total_paid_amount;
var operation_type;
var transaction_amount;
var collectorId;
var coupon_id;
var installments;
var authorization_code;
var taxes_amount;
var coupon_amount;
var installment_amount;
var activation_uri;
var overpaid_amount;
var card_id;
var issuer_id;
var payment_method_id;
var payment_type;
var deferred_period;
var atm_transfer_referenceTransaction_id;
var atm_transfer_referenceCompany_id;
var site_id;
var payer_id;
var marketplace_fee;
var order_id;
var transaction_order_id;
var k;
var count_k;
var strVal;
var itemSeller_custom_field;
var itemCondition;
var itemCategory_id;
var itemVariation_id;
var itemSeller_sku;
var itemWarranty;
var itemId;
var itemTitle;
var quantity;
var differential_pricing_id;
var sale_fee;
var listing_type_id;
var base_currency_id;
var unit_price;
var full_unit_price;
var base_exchange_rate;
var manufacturing_days;
var id_str;
var name;
var query = jResp.StringOf("query");
var sortId = jResp.StringOf("sort.id");
var sortName = jResp.StringOf("sort.name");
var pagingTotal = jResp.IntOf("paging.total");
var pagingOffset = jResp.IntOf("paging.offset");
var pagingLimit = jResp.IntOf("paging.limit");
var display = jResp.StringOf("display");
var i = 0;
var count_i = jResp.SizeOfArray("results");
while (i < count_i) {
jResp.I = i;
sellerPhoneNumber = jResp.StringOf("results[i].seller.phone.number");
sellerPhoneExtension = jResp.StringOf("results[i].seller.phone.extension");
sellerPhoneArea_code = jResp.StringOf("results[i].seller.phone.area_code");
sellerPhoneVerified = jResp.BoolOf("results[i].seller.phone.verified");
sellerAlternative_phoneNumber = jResp.StringOf("results[i].seller.alternative_phone.number");
sellerAlternative_phoneExtension = jResp.StringOf("results[i].seller.alternative_phone.extension");
sellerAlternative_phoneArea_code = jResp.StringOf("results[i].seller.alternative_phone.area_code");
sellerNickname = jResp.StringOf("results[i].seller.nickname");
sellerLast_name = jResp.StringOf("results[i].seller.last_name");
sellerId = jResp.IntOf("results[i].seller.id");
sellerFirst_name = jResp.StringOf("results[i].seller.first_name");
sellerEmail = jResp.StringOf("results[i].seller.email");
fulfilled = jResp.BoolOf("results[i].fulfilled");
buying_mode = jResp.StringOf("results[i].buying_mode");
taxesAmount = jResp.StringOf("results[i].taxes.amount");
taxesCurrency_id = jResp.StringOf("results[i].taxes.currency_id");
order_requestChange = jResp.StringOf("results[i].order_request.change");
order_requestReturn = jResp.StringOf("results[i].order_request.return");
expiration_date = jResp.StringOf("results[i].expiration_date");
feedbackSale = jResp.StringOf("results[i].feedback.sale");
feedbackPurchase = jResp.StringOf("results[i].feedback.purchase");
shippingId = jResp.IntOf("results[i].shipping.id");
jResp.DtOf("results[i].date_closed",false,date_closed);
id = jResp.IntOf("results[i].id");
manufacturing_ending_date = jResp.StringOf("results[i].manufacturing_ending_date");
hidden_for_seller = jResp.BoolOf("results[i].hidden_for_seller");
jResp.DtOf("results[i].date_last_updated",false,date_last_updated);
last_updated = jResp.StringOf("results[i].last_updated");
comments = jResp.StringOf("results[i].comments");
pack_id = jResp.StringOf("results[i].pack_id");
couponAmount = jResp.IntOf("results[i].coupon.amount");
couponId = jResp.StringOf("results[i].coupon.id");
shipping_cost = jResp.IntOf("results[i].shipping_cost");
jResp.DtOf("results[i].date_created",false,date_created);
application_id = jResp.StringOf("results[i].application_id");
pickup_id = jResp.StringOf("results[i].pickup_id");
status_detail = jResp.StringOf("results[i].status_detail");
buyerBilling_infoDoc_number = jResp.StringOf("results[i].buyer.billing_info.doc_number");
buyerBilling_infoDoc_type = jResp.StringOf("results[i].buyer.billing_info.doc_type");
buyerPhoneNumber = jResp.StringOf("results[i].buyer.phone.number");
buyerPhoneExtension = jResp.StringOf("results[i].buyer.phone.extension");
buyerPhoneArea_code = jResp.StringOf("results[i].buyer.phone.area_code");
buyerPhoneVerified = jResp.BoolOf("results[i].buyer.phone.verified");
buyerAlternative_phoneNumber = jResp.StringOf("results[i].buyer.alternative_phone.number");
buyerAlternative_phoneExtension = jResp.StringOf("results[i].buyer.alternative_phone.extension");
buyerAlternative_phoneArea_code = jResp.StringOf("results[i].buyer.alternative_phone.area_code");
buyerNickname = jResp.StringOf("results[i].buyer.nickname");
buyerLast_name = jResp.StringOf("results[i].buyer.last_name");
buyerId = jResp.IntOf("results[i].buyer.id");
buyerFirst_name = jResp.StringOf("results[i].buyer.first_name");
buyerEmail = jResp.StringOf("results[i].buyer.email");
total_amount = jResp.StringOf("results[i].total_amount");
paid_amount = jResp.StringOf("results[i].paid_amount");
currency_id = jResp.StringOf("results[i].currency_id");
status = jResp.StringOf("results[i].status");
j = 0;
count_j = jResp.SizeOfArray("results[i].payments");
while (j < count_j) {
jResp.J = j;
reason = jResp.StringOf("results[i].payments[j].reason");
status_code = jResp.StringOf("results[i].payments[j].status_code");
total_paid_amount = jResp.StringOf("results[i].payments[j].total_paid_amount");
operation_type = jResp.StringOf("results[i].payments[j].operation_type");
transaction_amount = jResp.StringOf("results[i].payments[j].transaction_amount");
jResp.DtOf("results[i].payments[j].date_approved",false,date_approved);
collectorId = jResp.IntOf("results[i].payments[j].collector.id");
coupon_id = jResp.StringOf("results[i].payments[j].coupon_id");
installments = jResp.IntOf("results[i].payments[j].installments");
authorization_code = jResp.StringOf("results[i].payments[j].authorization_code");
taxes_amount = jResp.IntOf("results[i].payments[j].taxes_amount");
id = jResp.IntOf("results[i].payments[j].id");
jResp.DtOf("results[i].payments[j].date_last_modified",false,date_last_modified);
coupon_amount = jResp.IntOf("results[i].payments[j].coupon_amount");
shipping_cost = jResp.IntOf("results[i].payments[j].shipping_cost");
installment_amount = jResp.StringOf("results[i].payments[j].installment_amount");
jResp.DtOf("results[i].payments[j].date_created",false,date_created);
activation_uri = jResp.StringOf("results[i].payments[j].activation_uri");
overpaid_amount = jResp.IntOf("results[i].payments[j].overpaid_amount");
card_id = jResp.IntOf("results[i].payments[j].card_id");
status_detail = jResp.StringOf("results[i].payments[j].status_detail");
issuer_id = jResp.StringOf("results[i].payments[j].issuer_id");
payment_method_id = jResp.StringOf("results[i].payments[j].payment_method_id");
payment_type = jResp.StringOf("results[i].payments[j].payment_type");
deferred_period = jResp.StringOf("results[i].payments[j].deferred_period");
atm_transfer_referenceTransaction_id = jResp.StringOf("results[i].payments[j].atm_transfer_reference.transaction_id");
atm_transfer_referenceCompany_id = jResp.StringOf("results[i].payments[j].atm_transfer_reference.company_id");
site_id = jResp.StringOf("results[i].payments[j].site_id");
payer_id = jResp.IntOf("results[i].payments[j].payer_id");
marketplace_fee = jResp.StringOf("results[i].payments[j].marketplace_fee");
order_id = jResp.IntOf("results[i].payments[j].order_id");
currency_id = jResp.StringOf("results[i].payments[j].currency_id");
status = jResp.StringOf("results[i].payments[j].status");
transaction_order_id = jResp.StringOf("results[i].payments[j].transaction_order_id");
k = 0;
count_k = jResp.SizeOfArray("results[i].payments[j].available_actions");
while (k < count_k) {
jResp.K = k;
strVal = jResp.StringOf("results[i].payments[j].available_actions[k]");
k = k+1;
}
j = j+1;
}
j = 0;
count_j = jResp.SizeOfArray("results[i].order_items");
while (j < count_j) {
jResp.J = j;
itemSeller_custom_field = jResp.StringOf("results[i].order_items[j].item.seller_custom_field");
itemCondition = jResp.StringOf("results[i].order_items[j].item.condition");
itemCategory_id = jResp.StringOf("results[i].order_items[j].item.category_id");
itemVariation_id = jResp.StringOf("results[i].order_items[j].item.variation_id");
itemSeller_sku = jResp.StringOf("results[i].order_items[j].item.seller_sku");
itemWarranty = jResp.StringOf("results[i].order_items[j].item.warranty");
itemId = jResp.StringOf("results[i].order_items[j].item.id");
itemTitle = jResp.StringOf("results[i].order_items[j].item.title");
quantity = jResp.IntOf("results[i].order_items[j].quantity");
differential_pricing_id = jResp.StringOf("results[i].order_items[j].differential_pricing_id");
sale_fee = jResp.StringOf("results[i].order_items[j].sale_fee");
listing_type_id = jResp.StringOf("results[i].order_items[j].listing_type_id");
base_currency_id = jResp.StringOf("results[i].order_items[j].base_currency_id");
unit_price = jResp.StringOf("results[i].order_items[j].unit_price");
full_unit_price = jResp.StringOf("results[i].order_items[j].full_unit_price");
base_exchange_rate = jResp.StringOf("results[i].order_items[j].base_exchange_rate");
currency_id = jResp.StringOf("results[i].order_items[j].currency_id");
manufacturing_days = jResp.StringOf("results[i].order_items[j].manufacturing_days");
k = 0;
count_k = jResp.SizeOfArray("results[i].order_items[j].item.variation_attributes");
while (k < count_k) {
jResp.K = k;
k = k+1;
}
j = j+1;
}
j = 0;
count_j = jResp.SizeOfArray("results[i].tags");
while (j < count_j) {
jResp.J = j;
strVal = jResp.StringOf("results[i].tags[j]");
j = j+1;
}
j = 0;
count_j = jResp.SizeOfArray("results[i].mediations");
while (j < count_j) {
jResp.J = j;
j = j+1;
}
i = i+1;
}
i = 0;
count_i = jResp.SizeOfArray("available_sorts");
while (i < count_i) {
jResp.I = i;
id_str = jResp.StringOf("available_sorts[i].id");
name = jResp.StringOf("available_sorts[i].name");
i = i+1;
}
i = 0;
count_i = jResp.SizeOfArray("filters");
while (i < count_i) {
jResp.I = i;
i = i+1;
}
|
