Magento – magento 2 web rest api – Get all products with a specific attribute code

One order can contain multiple products, which are represented as order items in the context of order. With order APIs you cannot get order list with order items in one request. But it can be done as follows:

1. Get list of order IDs which you are interested in (e.g. using request provided in the question)
2. To get product details use \Magento\Sales\Api\OrderItemRepositoryInterface::getList($searchCriteria). Via REST it is available as GET <base_url>/V1/orders/items. Iterate through orders from the previous step and for each one get its items, in search criteria specify filter by order ID

You can use the following rest PUT call:

/rest/V1/products/{SKU}

Passing the following json:

{
"product": {
  "price": 9.63,
  "extension_attributes": {
    "stock_item": {
      "qty": 63
    }
  }
 }
}

So you can update price and stock quantity with one single call. You can remove the extension_attributes value, if you only want to update the price.

EDIT

You will need a quotation mark for your price, like this below. I don't quite understand why because the price should be a double variable in the database.

{ 
    "product":{ 
        "price":"9.63",
        "extension_attributes":{ 
            "stock_item":{ 
                "qty":63
            }
        }
    }
}