Delphi ActiveX

Etsy: Get the Inventory for a Listing

See more Etsy Examples

Gets the inventory for a listing. Delphi ActiveX

uses
    Winapi.Windows, Winapi.Messages, System.SysUtils, System.Variants, System.Classes, Vcl.Graphics,
    Vcl.Controls, Vcl.Forms, Vcl.Dialogs, Vcl.StdCtrls, Chilkat_TLB;

...

procedure TForm1.Button1Click(Sender: TObject);
var
success: Integer;
http: TChilkatHttp;
sbResponseBody: TChilkatStringBuilder;
jResp: TChilkatJsonObject;
respStatusCode: Integer;
product_id: Integer;
j: Integer;
count_j: Integer;
offering_id: Integer;
priceAmount: Integer;
priceDivisor: Integer;
priceCurrency_code: WideString;
priceCurrency_formatted_short: WideString;
priceCurrency_formatted_long: WideString;
priceCurrency_formatted_raw: WideString;
quantity: Integer;
count: Integer;
paramsListing_id: WideString;
paramsWrite_missing_inventory: Integer;
v_type: WideString;
i: Integer;
count_i: Integer;

begin
success := 0;

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

http := TChilkatHttp.Create(Self);

// Implements the following CURL command:

// curl -X GET \
//   https://openapi.etsy.com/v2/listings/listing_id/inventory?api_key=MY_ETSY_KEYSTRING

sbResponseBody := TChilkatStringBuilder.Create(Self);
success := http.QuickGetSb('https://openapi.etsy.com/v2/listings/listing_id/inventory?api_key=MY_ETSY_KEYSTRING',sbResponseBody.ControlInterface);
if (success = 0) then
  begin
    Memo1.Lines.Add(http.LastErrorText);
    Exit;
  end;

jResp := TChilkatJsonObject.Create(Self);
jResp.LoadSb(sbResponseBody.ControlInterface);
jResp.EmitCompact := 0;

Memo1.Lines.Add('Response Body:');
Memo1.Lines.Add(jResp.Emit());

respStatusCode := http.LastStatus;
Memo1.Lines.Add('Response Status Code = ' + IntToStr(respStatusCode));
if (respStatusCode >= 400) then
  begin
    Memo1.Lines.Add('Response Header:');
    Memo1.Lines.Add(http.LastHeader);
    Memo1.Lines.Add('Failed.');
    Exit;
  end;

// Sample JSON response:
// (Sample code for parsing the JSON response is shown below)

// {
//   "count": 1,
//   "results": {
//     "products": [
//       {
//         "product_id": 3361120103,
//         "property_values": [
//         ],
//         "offerings": [
//           {
//             "offering_id": 3579642570,
//             "price": {
//               "amount": 16000,
//               "divisor": 100,
//               "currency_code": "USD",
//               "currency_formatted_short": "$160.00",
//               "currency_formatted_long": "$160.00 USD",
//               "currency_formatted_raw": "160.00"
//             },
//             "quantity": 1
//           }
//         ]
//       }
//     ]
//   },
//   "params": {
//     "listing_id": "720138253",
//     "write_missing_inventory": false
//   },
//   "type": "ListingInventory",
//   "pagination": {}
// }

// Sample code for parsing the JSON response...
// Use the following online tool to generate parsing code from sample JSON:
// Generate Parsing Code from JSON

count := jResp.IntOf('count');
paramsListing_id := jResp.StringOf('params.listing_id');
paramsWrite_missing_inventory := jResp.BoolOf('params.write_missing_inventory');
v_type := jResp.StringOf('type');
i := 0;
count_i := jResp.SizeOfArray('results.products');
while i < count_i do
  begin
    jResp.I := i;
    product_id := jResp.IntOf('results.products[i].product_id');
    j := 0;
    count_j := jResp.SizeOfArray('results.products[i].property_values');
    while j < count_j do
      begin
        jResp.J := j;
        j := j + 1;
      end;

    j := 0;
    count_j := jResp.SizeOfArray('results.products[i].offerings');
    while j < count_j do
      begin
        jResp.J := j;
        offering_id := jResp.IntOf('results.products[i].offerings[j].offering_id');
        priceAmount := jResp.IntOf('results.products[i].offerings[j].price.amount');
        priceDivisor := jResp.IntOf('results.products[i].offerings[j].price.divisor');
        priceCurrency_code := jResp.StringOf('results.products[i].offerings[j].price.currency_code');
        priceCurrency_formatted_short := jResp.StringOf('results.products[i].offerings[j].price.currency_formatted_short');
        priceCurrency_formatted_long := jResp.StringOf('results.products[i].offerings[j].price.currency_formatted_long');
        priceCurrency_formatted_raw := jResp.StringOf('results.products[i].offerings[j].price.currency_formatted_raw');
        quantity := jResp.IntOf('results.products[i].offerings[j].quantity');
        j := j + 1;
      end;

    i := i + 1;
  end;
end;