########################################################## REQUEST V1 - export orders ########################################################## GET /sr_company_ws/api/export/order/d07a3fa9-8336-4512-ad87-dac6277b4c9f?body=%7B%22code%22%3A%5B%2215690%22%2C%2211-13067-60538%22%5D%2C%22status%22%3A%5B%22sent%22%2C%22accepted%22%5D%2C%22startDate%22%3A%222025-03-16%22%2C%22startModified%22%3A%222025-03-16%22%2C%22endDate%22%3A%222025-05-14%22%2C%22endModified%22%3A%222025-07-14%22%2C%22tags%22%3A%5B%22menu-tags6%22%2C%22menu-tags2%22%5D%2C%22offset%22%3A0%2C%22limit%22%3A3%2C%22columnSeparator%22%3A%22%24%22%2C%22writeHeading%22%3Atrue%2C%22format%22%3A%22json%22%7D body decodificato body= { "code":["15690","11-13067-60538"], "status":["sent","accepted"], "startDate":"2025-03-16", "startModified":"2025-03-16", "endDate":"2025-05-14", "endModified":"2025-07-14", "tags":["menu-tags6","menu-tags2"], "offset":0, "limit":3, "columnSeparator":"$", "writeHeading":true, "format":"json" } ########################################################## REUQEST V1 - get orders ########################################################## POST /sr_company_ws/api/order/d07a3fa9-8336-4512-ad87-dac6277b4c9f Accept: application/csv Content-Type: application/json { "code":["15690","11-13067-60538"], "status": ["sent","accepted"], "startDate": "2025-03-16", "startModified": "2025-03-16", "endDate": "2025-05-14", "endModified": "2025-07-14", "tags": ["menu-tags6","menu-tags2"], "offset": 0, "limit": 3, "columnSeparator": "$", "writeHeading": true, "format": "csv" } ########################################################## REQUEST V2 ########################################################## GET /sr_company_ws/api/v2/order?code=15690,11-13067-60538&status=sent,accepted&start_date=2025-03-16&start_modified=2025-03-16&end_date=2025-05-14&end_modified=2025-07-14&tags=menu-tags6,menu-tags2&offset=0&limit=3&column_separator=$&write_heading=true&format=csv Authorization: Bearer eyJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJzcm9fYXBpIiwic3ViIjoiNDciLCJhdWQiOlsic3JvX2FwaSJdLCJpYXQiOjE3NTM3ODc3NzcsImV4cCI6MTc1Mzc4ODY3NywianRpIjoiMzYxNGE3MjAtYzI0Yy00M2MyLWI3ODAtZmZjODE1OTVlYzEwIiwiYWNjb3VudF9pZCI6NDcsInVzZXJuYW1lIjoibS5jcmVtb25pbmlAc2VsbHJhcGlkby5jb20iLCJjb21wYW55X2lkIjozMTAsInRva2VuX25hbWUiOiJhY2Nlc3NfdG9rZW4iLCJleHBpcmVfYXQiOiIyMDI1LTA3LTI5VDExOjMxOjE3Ljc4MzA2NzgyMVoiLCJjcmVhdGlvbl9hdCI6IjIwMjUtMDctMjlUMTE6MTY6MTcuNzgzMDY3ODIxWiIsInJlZnJlc2hfanRpIjoiMzgyMmZlODUtN2MyMy00MDMzLWI4ODktMjRhMzczZDQwZGY5In0.eUEtodQNunimWcUwcKl91TCybu2x8WJ-2JutbHTX5qc lista parametri decodificata code:15690,11-13067-60538 status:sent,accepted start_date:2025-03-16 start_modified:2025-03-16 end_date:2025-05-14 end_modified:2025-07-14 tags:menu-tags6,menu-tags2 offset:0 limit:3 column_separator:$ write_heading:true format:csv MODIFICHE: endpoint unico, parametri estratti dal contenitore "body" e label normalizzate con snake case (es. startDate --> start_date), array di stringhe sostituiti da stringhe csv ########################################################## RESPONSE (identica per tutti e tre i casi) ########################################################## HTTP/1.1 200 OK Content-Type: application/json;charset=UTF-8 Payload { "orders": [ { "head": { "id": 6714, "shop": 168, "customer": 12, "courier": null, "code": "11-13067-60538", "code_number": 295, "marketplace_code": "Ebay", "channel_code": "Italy", "courier_code": "GLS Italy", "shipping_code": "IT_BartoliniBRTExpressEbay", "insurance_code": "", "payment_code": "CreditCard", "supplier_code": "", "buyer_loc_place": 0, "buyer_loc_place_dd": 0, "merchant_id": "merchant", "fields_lock": "", "date_order": "2025-05-12T17:27:06Z", "reference_1": "", "reference_2": "", "buyer_user_id": "mattimerlott-0", "buyer_checkout_message": "", "buyer_email": "", "buyer_token": "nY+sHZ2PrBmdj6wVnY+sEZ2PrA2dj6AAlIaoD5aKpgydj6x9nY+seQ==", "shipping_price": 5.0, "shipping_insurance_price": 0.0, "marketplace_fee": 2.45, "paypal_fee": 0.0, "shipped_by_marketplace": 0, "is_prime": 0, "cod_cash_only": 0, "cod_option": "", "cod_price": 0.0, "price_discount_markup": 0.0, "buyer_name": "Nome Cognome", "buyer_address1": "Via Nomevia 45", "buyer_address2": "", "buyer_zip": "CAP", "buyer_city": "Città", "buyer_province": "Provincia", "buyer_country": "ITA", "buyer_latitude": 0.0, "buyer_longitude": 0.0, "buyer_phone": "012345", "buyer_fax": "", "buyer_mobile": "", "buyer_fiscal_code": "", "buyer_vat": "", "currency": "EUR", "price": 9.0, "status": "sent", "status_old": "sent", "status_message": "", "date_payment": "2025-05-12T17:27:05Z", "date_shipping": "2025-05-13T13:40:58Z", "weight": 5.0, "tracking": "LT850004073", "note": "", "payment_note": "", "buyer_name_dd": "Buyer", "buyer_address1_dd": "Via Nomevia 45", "buyer_address2_dd": "", "buyer_zip_dd": "CAP", "buyer_city_dd": "Città", "buyer_province_dd": "Provincia", "buyer_country_dd": "ITA", "buyer_latitude_dd": 0.0, "buyer_longitude_dd": 0.0, "buyer_phone_dd": "012345", "buyer_fax_dd": "", "buyer_mobile_dd": "", "shipping_note": "", "paypal_transaction_id": "", "billed": 0, "tags": "menu-tags2;", "courier_info": {}, "problem_description": "", "shipping_cost": 0.0, "feedbacks": {}, "feedbacks_date": "2025-05-12T17:44:17Z", "content_type": "", "hidden": 0, "upload_status": { "request_payload": "{\"CreatedTime\":\"2025-05-12T19:27:06.000Z\",\"AmountPaid\":{\"currencyID\":\"EUR\",\"content\":9},\"OrderID\":\"11-13067-60538\",\"PaymentHoldStatus\":\"None\",\"TransactionArray\":{\"Transaction\":{\"Status\":{\"ReturnStatus\":\"NotApplicable\",\"InquiryStatus\":\"NotApplicable\",\"PaymentHoldStatus\":\"None\"},\"ActualHandlingCost\":{\"currencyID\":\"EUR\",\"content\":0},\"Platform\":\"eBay\",\"ActualShippingCost\":{\"currencyID\":\"EUR\",\"content\":5},\"ShippingDetails\":{\"SalesTax\":{\"SalesTaxPercent\":0},\"ShipmentTrackingDetails\":{\"ShipmentTrackingNumber\":\"LT850004073\",\"ShippingCarrierUsed\":\"GLS Italy\"},\"SellingManagerSalesRecordNumber\":295},\"TransactionSiteID\":\"Italy\",\"Buyer\":{\"Email\":\"Invalid Request\",\"UserLastName\":\"Merlotto\",\"UserFirstName\":\"Mattia\"},\"TransactionPrice\":{\"currencyID\":\"EUR\",\"content\":4},\"ShippedTime\":\"2025-05-13T15:40:58.000Z\",\"QuantityPurchased\":1,\"TransactionID\":10072442519011,\"ExtendedOrderID\":\"11-13067-60538\",\"eBayPlusTransaction\":false,\"Item\":{\"Site\":\"Italy\",\"Title\":\"284 Fiat 7579570 TAPPO MONOBLOCCO FIAT PANDA\",\"SKU\":\"14_284\",\"ItemID\":197139218223,\"Location\":\"priverno\"},\"Taxes\":{\"TaxDetails\":{\"TaxDescription\":\"SalesTax\",\"TaxAmount\":{\"currencyID\":\"EUR\",\"content\":0},\"TaxOnSubtotalAmount\":{\"currencyID\":\"EUR\",\"content\":0},\"Imposition\":\"SalesTax\",\"TaxOnShippingAmount\":{\"currencyID\":\"EUR\",\"content\":0},\"TaxOnHandlingAmount\":{\"currencyID\":\"EUR\",\"content\":0}},\"TotalTaxAmount\":{\"currencyID\":\"EUR\",\"content\":0}},\"ShippingServiceSelected\":{\"ShippingPackageInfo\":{\"ActualDeliveryTime\":\"2025-05-20T12:07:00.000Z\",\"EstimatedDeliveryTimeMin\":\"2025-05-14T22:00:00.000Z\",\"EstimatedDeliveryTimeMax\":\"2025-05-18T22:00:00.000Z\"}},\"CreatedDate\":\"2025-05-12T19:27:06.000Z\",\"InventoryReservationID\":10072442519011,\"FinalValueFee\":{\"currencyID\":\"EUR\",\"content\":2.45},\"OrderLineItemID\":\"197139218223-10072442519011\"}},\"EIASToken\":\"nY+sHZ2PrBmdj6wVnY+sEZ2PrA2dj6AAlIaoD5aKpgydj6x9nY+seQ==\",\"OrderStatus\":\"Completed\",\"BuyerUserID\":\"mattimerlott-0\",\"IsMultiLegShipping\":false,\"AdjustmentAmount\":{\"currencyID\":\"EUR\",\"content\":0},\"SellerEIASToken\":\"nY+sHZ2PrBmdj6wVnY+sEZ2PrA2dj6MCmYapC5OKpQSdj6x9nY+seQ==\",\"CheckoutStatus\":{\"Status\":\"Complete\",\"LastModifiedTime\":\"2025-05-20T11:22:42.000Z\",\"PaymentInstrument\":\"PayPal\",\"PaymentMethod\":\"CreditCard\",\"IntegratedMerchantCreditCardEnabled\":false,\"eBayPaymentStatus\":\"NoPaymentFailure\"},\"AmountSaved\":{\"currencyID\":\"EUR\",\"content\":0},\"ShippingDetails\":{\"SalesTax\":{\"SalesTaxPercent\":0,\"ShippingIncludedInTax\":false,\"SalesTaxAmount\":{\"currencyID\":\"EUR\",\"content\":0}},\"ShippingServiceOptions\":{\"ExpeditedService\":false,\"ShippingTimeMax\":2,\"ShippingServiceCost\":{\"currencyID\":\"EUR\",\"content\":5},\"ShippingService\":\"IT_BartoliniBRTExpressEbay\",\"ShippingServicePriority\":1,\"ShippingTimeMin\":1},\"SellingManagerSalesRecordNumber\":295},\"Subtotal\":{\"currencyID\":\"EUR\",\"content\":4},\"PaidTime\":\"2025-05-12T19:27:05.390Z\",\"ContainseBayPlusTransaction\":false,\"ShippedTime\":\"2025-05-13T15:40:58.000Z\",\"MonetaryDetails\":{\"Payments\":{\"Payment\":{\"Payer\":{\"type\":\"eBayUser\",\"content\":\"mattimerlott-0\"},\"ReferenceID\":{\"type\":\"ExternalTransactionID\",\"content\":2461729608401},\"FeeOrCreditAmount\":{\"currencyID\":\"EUR\",\"content\":0},\"PaymentTime\":\"2025-05-12T19:27:05.390Z\",\"PaymentAmount\":{\"currencyID\":\"EUR\",\"content\":9},\"Payee\":{\"type\":\"eBayUser\",\"content\":\"lea-line\"},\"PaymentStatus\":\"Succeeded\"}}},\"ExtendedOrderID\":\"11-13067-60538\",\"ShippingServiceSelected\":{\"ShippingServiceCost\":{\"currencyID\":\"EUR\",\"content\":5},\"ShippingService\":\"IT_BartoliniBRTExpressEbay\",\"ShippingPackageInfo\":{\"ActualDeliveryTime\":\"2025-05-20T12:07:00.000Z\"}},\"ShippingAddress\":{\"Street2\":\"\",\"Street1\":\"Via Nomevia 45\",\"AddressOwner\":\"eBay\",\"CountryName\":\"Italy\",\"Phone\":012345,\"StateOrProvince\":\"Provincia\",\"Country\":\"IT\",\"PostalCode\":\"CAP\",\"CityName\":Città\",\"AddressID\":10002639459486,\"Name\":\"Nome\"},\"Total\":{\"currencyID\":\"EUR\",\"content\":9},\"CancelStatus\":\"NotApplicable\",\"SellerUserID\":\"merchant\"}", "request_date": "Wed May 28 11:19:19 UTC 2025" } }, "marketplace_country": "ITA", "agent": "", "buyer_invoice_ecode": "", "buyer_pec": "", "date_last_ship": null, "date_last_delivery": "2025-05-18T20:00:00Z", "created": "2025-05-12T17:32:28Z", "modified": "2025-05-28T09:19:19Z", "is_b2b": 0, "billing_info": {}, "force_profit_loss_calculation": "false", "total_tax": 0.0, "reservation": 0, "dbClass": "com.sellrapido.common.model.db.company.Order_head", "tags_label": ";CONTRORDINE DA FARE;" }, "rows": [ { "id": 7040, "order_head": 6714, "order_row_supplier": null, "supplier": null, "order_supplier_code": "", "courier_code": "GLS Italy", "tracking": "", "fields_lock": "", "shipping_cost": 1.0, "shipping_code": "IT_BartoliniBRTExpressEbay", "transaction_id": "10072442519011", "product_id": "197139218223", "sku": "14_284", "ean": "", "brand": "Fiat", "mpn": "x", "sku_parent": "", "title": "284 Fiat 7579570 TAPPO MONOBLOCCO FIAT PANDA", "title_extra": "", "quantity": 1, "stock_unloaded": 1, "price": 4.0, "price_total": 4.0, "price_discount_markup": 0.0, "price_cost": 3.0, "refund_price": 0.0, "refund_date": null, "refund_reason": "", "shipping_price": 5.0, "shipping_insurance_price": 0.0, "date_shipping": "2025-05-13T13:40:58Z", "shipping_note": "", "cod_price": 0.0, "marketplace_fee": 0.0, "weight": 5.0, "note": "", "vat_perc": 22.0, "image_url": "", "category_id": "", "category_name": "", "date_payment": null, "product_info": { "fieldConstraints": null, "product_id": 2054, "catalog_id": 14, "catalog_code": "CUSTOM", "catalog_name": "listino_catene", "sku": "284", "sku_noprefix": null, "ean": "", "mpn": "x", "isbn": "", "brand": "Fiat", "catalog_category1": "RICAMBI", "catalog_category2": "PF e SPED", "catalog_category3": "SPED 2GG", "url_image1": "https://app.sellrapido.com/static/cmp/3697/ctl/34/images/18886479-1-1627883055441.jpg", "price1": 3.0, "price_shipping1": 1.0, "vat_perc": 0.0, "sku_variation": null, "ean_variation": "", "warehouse": "", "on_demand_days": 0, "on_demand": false, "extra1": "", "extra2": "", "extra3": "", "extra4": "", "extra5": "", "extra6": "", "extra7": "", "extra8": "", "extra9": "", "price2": 0.0, "price3": 0.0, "price4": 0.0, "price5": 0.0, "price6": 0.0, "price_shipping2": 0.0, "price_shipping3": 0.0, "price_shipping4": 0.0, "price_shipping5": 0.0, "price_shipping6": 0.0, "price_cost": 0.0, "variations": [], "compatibility": {}, "attributes": {}, "listingFees": { "fieldConstraints": null, "marketplace_fee": 0.0, "shipping_price": 0.0, "shipping_cost": 0.0, "fee_additional": 0.0, "paypal_fee": 0.0 }, "condition_code": "none", "condition_description": "", "supplier_sku_prefix": "", "repricing": false, "no_repricing_price": null, "lowest_price": 0.0, "quantity": 10.0, "is_sro": true, "listing_price": 4.0, "listing_price_noshipping": 4.0, "listing_price_shipping1": 0.0, "listing_priceB2B": 0.0, "origin_country": "IT", "title": "7579570 TAPPO MONOBLOCCO FIAT PANDA", "delivery_days": 1 }, "on_demand_date": null, "created": "2025-05-12T17:32:29Z", "modified": "2025-05-28T09:19:20Z", "order_supplier": 0, "refund_supplier_quantity": 0, "refund_marketplace_fee": 0.0, "product_tax": 0.0, "no_vat": "false", "courier_info": {} } ] }, { "head": { "id": 2476, "shop": 168, "customer": 1499, "courier": null, "code": "15690", "code_number": 0, "marketplace_code": "Scaboo", "channel_code": "Scaboo Italian", "courier_code": "BARTOLINI1", "shipping_code": "corriere (consegna in circa 3/4 gg lavorativi dall'accredito del vostro pagamento) - servizio di tracciamento corriere con track", "insurance_code": "", "payment_code": "Ordine Generato In Automatico Tramite API", "supplier_code": "Catalogo prodotti italiano", "buyer_loc_place": 0, "buyer_loc_place_dd": 0, "merchant_id": "merchant", "fields_lock": "", "date_order": "2025-03-17T06:12:08Z", "reference_1": "", "reference_2": "", "buyer_user_id": "", "buyer_checkout_message": "{"sr_origin_catalogs":{"77_BD_IT_0001_070.00000000010969":12}}", "buyer_email": "email", "buyer_token": "", "shipping_price": 0.0, "shipping_insurance_price": 0.0, "marketplace_fee": 0.0, "paypal_fee": 0.0, "shipped_by_marketplace": 0, "is_prime": 0, "cod_cash_only": 0, "cod_option": "", "cod_price": 0.0, "price_discount_markup": 0.0, "buyer_name": "Buyer", "buyer_address1": "Viale Nomevia", "buyer_address2": "", "buyer_zip": "CAP", "buyer_city": "Città", "buyer_province": "ITALIA", "buyer_country": "ITA", "buyer_latitude": 0.0, "buyer_longitude": 0.0, "buyer_phone": "012345", "buyer_fax": "", "buyer_mobile": "", "buyer_fiscal_code": "012345", "buyer_vat": "012345", "currency": "EUR", "price": 13.11, "status": "sent", "status_old": "accepted", "status_message": "", "date_payment": "2025-03-17T06:12:08Z", "date_shipping": null, "weight": 0.0, "tracking": "280340324736", "note": "", "payment_note": "", "buyer_name_dd": "Nome Cognome", "buyer_address1_dd": "Via Nomevia 17/A", "buyer_address2_dd": "", "buyer_zip_dd": "CAP", "buyer_city_dd": "Città", "buyer_province_dd": "Provincia", "buyer_country_dd": "ITA", "buyer_latitude_dd": 0.0, "buyer_longitude_dd": 0.0, "buyer_phone_dd": "012345", "buyer_fax_dd": "", "buyer_mobile_dd": "", "shipping_note": "", "paypal_transaction_id": "", "billed": 0, "tags": "menu-tags7;menu-tags6;", "courier_info": {}, "problem_description": "", "shipping_cost": 0.0, "feedbacks": {}, "feedbacks_date": null, "content_type": "", "hidden": 0, "marketplace_country": "ITA", "agent": "", "buyer_invoice_ecode": "m5uxcr1", "buyer_pec": "pec", "date_last_ship": null, "date_last_delivery": null, "created": "2025-03-17T06:13:25Z", "modified": "2025-05-21T08:07:24Z", "is_b2b": 0, "billing_info": {}, "force_profit_loss_calculation": "false", "total_tax": 2.36, "reservation": 0, "dbClass": "com.sellrapido.common.model.db.company.Order_head", "tags_label": "" }, "rows": [ { "id": 3213, "order_head": 2476, "order_row_supplier": null, "supplier": null, "order_supplier_code": "", "courier_code": "", "tracking": "", "fields_lock": "", "shipping_cost": 0.0, "shipping_code": "", "transaction_id": "15690-451", "product_id": "451", "sku": "77_BD_IT_0001_070.00000000010969", "ean": "8000866109697", "brand": "Dc Comics", "mpn": "", "sku_parent": "", "title": "Borraccia Ciclo Batman Bici Bambino 350 Ml Nero Giallo", "title_extra": "", "quantity": 1, "stock_unloaded": 1, "price": 13.11, "price_total": 13.11, "price_discount_markup": 0.0, "price_cost": 9.95, "refund_price": 0.0, "refund_date": null, "refund_reason": "", "shipping_price": 0.0, "shipping_insurance_price": 0.0, "date_shipping": null, "shipping_note": "", "cod_price": 0.0, "marketplace_fee": 0.0, "weight": 0.0, "note": "", "vat_perc": 22.0, "image_url": "https://scambiodati.ecommercezone.it/img/10969 1.jpg", "category_id": "", "category_name": "", "date_payment": null, "product_info": { "fieldConstraints": null, "product_id": 258354018, "catalog_id": 77, "catalog_code": "CUSTOM", "catalog_name": "COLZANI_AUTO/MOTO_ITA", "sku": "BD_IT_0001_070.00000000010969", "sku_noprefix": null, "ean": "8000866109697", "mpn": "", "isbn": "", "brand": "Dc Comics", "catalog_category1": "CICLO", "catalog_category2": "LINEA BAMBINO", "catalog_category3": "BORRACCE", "url_image1": "https://scambiodati.ecommercezone.it/img/10969 1.jpg", "price1": 9.95, "price_shipping1": 0.0, "vat_perc": 0.0, "sku_variation": null, "ean_variation": "", "warehouse": "", "on_demand_days": 0, "on_demand": false, "extra1": "", "extra2": "", "extra3": "", "extra4": "", "extra5": "", "extra6": "", "extra7": "", "extra8": "", "extra9": "", "price2": 0.0, "price3": 0.0, "price4": 0.0, "price5": 0.0, "price6": 0.0, "price_shipping2": 0.0, "price_shipping3": 0.0, "price_shipping4": 0.0, "price_shipping5": 0.0, "price_shipping6": 0.0, "price_cost": 0.0, "variations": [], "compatibility": {}, "attributes": {}, "listingFees": { "fieldConstraints": null, "marketplace_fee": 0.0, "shipping_price": 0.0, "shipping_cost": 0.0, "fee_additional": 0.0, "paypal_fee": 0.0 }, "condition_code": "none", "condition_description": "", "supplier_sku_prefix": "", "repricing": false, "no_repricing_price": null, "lowest_price": 0.0, "quantity": 40.0, "is_sro": true, "listing_price": 13.11, "listing_price_noshipping": 13.11, "listing_price_shipping1": 0.0, "listing_priceB2B": 0.0, "origin_country": "", "title": "Borraccia ciclo Batman bici bambino 350 ml nero giallo" }, "on_demand_date": null, "created": "2025-03-17T06:13:28Z", "modified": "2025-03-17T10:00:21Z", "order_supplier": 0, "refund_supplier_quantity": 0, "refund_marketplace_fee": 0.0, "product_tax": 2.36, "no_vat": "false", "courier_info": {} } ] } ], "totalCount": 2, "offset": 0, "limit": 3 }