(Node.js) 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

Install Chilkat for Node.js and Electron using npm at Chilkat npm packages for Node.js Chilkat npm packages for Electron on Windows, Linux, MacOSX, and ARM

var os = require('os');
if (os.platform() == 'win32') {  
    if (os.arch() == 'ia32') {
        var chilkat = require('@chilkat/ck-node21-win-ia32');
    } else {
        var chilkat = require('@chilkat/ck-node21-win64'); 
    }
} else if (os.platform() == 'linux') {
    if (os.arch() == 'arm') {
        var chilkat = require('@chilkat/ck-node21-arm');
    } else if (os.arch() == 'x86') {
        var chilkat = require('@chilkat/ck-node21-linux32');
    } else {
        var chilkat = require('@chilkat/ck-node21-linux64');
    }
} else if (os.platform() == 'darwin') {
    if (os.arch() == 'arm64') {
        var chilkat = require('@chilkat/ck-node21-mac-m1');
    } else {
        var chilkat = require('@chilkat/ck-node21-macosx');
    }
}

function chilkatExample() {

    // This example assumes the Chilkat API to have been previously unlocked.
    // See Global Unlock Sample for sample code.

    var http = new chilkat.Http();

    // First get our previously obtained OAuth2 access token.
    var jsonToken = new chilkat.JsonObject();
    var 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 chilkat.StringBuilder();
    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 chilkat.JsonObject();
    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 chilkat.DtObj();
    var date_last_updated = new chilkat.DtObj();
    var date_created = new chilkat.DtObj();
    var date_approved = new chilkat.DtObj();
    var date_last_modified = new chilkat.DtObj();
    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;
    }


}

chilkatExample();