Data preparation before assigning attribute to an attribute set [Web API Tutorial]

Get the value for attributeGroupId attribute

Endpoint
GET http://<host>/rest/all/V1/products/attribute-sets/groups/list?searchCriteria[filterGroups][0][filters][0][field]=attribute_set_id&searchCriteria[filterGroups][0][filters][0][value]=9&searchCriteria[filterGroups][0][filters][0][conditionType]=eq&searchCriteria[filterGroups][0][filters][1][field]=attribute_group_name&searchCriteria[filterGroups][0][filters][1][value]=Product Details&searchCriteria[filterGroups][0][filters][1][conditionType]=eq&searchCriteria[pageSize]=1&searchCriteria[currentPage]=1

Here is how the request looks like in Postman

Response
Magento returns the item with attribute_group_id by given attribute_group_name and attribute_set_id

Complete cURL request

curl -X GET "$endpoint/all/V1/products/attribute-sets/groups/list?searchCriteria%5BfilterGroups%5D%5B0%5D%5Bfilters%5D%5B0%5D%5Bfield%5D=attribute_set_id&searchCriteria%5BfilterGroups%5D%5B0%5D%5Bfilters%5D%5B0%5D%5Bvalue%5D=9&searchCriteria%5BfilterGroups%5D%5B0%5D%5Bfilters%5D%5B0%5D%5BconditionType%5D=eq&searchCriteria%5BfilterGroups%5D%5B0%5D%5Bfilters%5D%5B1%5D%5Bfield%5D=attribute_group_name&searchCriteria%5BfilterGroups%5D%5B0%5D%5Bfilters%5D%5B1%5D%5Bvalue%5D=Product%20Details&searchCriteria%5BfilterGroups%5D%5B0%5D%5Bfilters%5D%5B1%5D%5BconditionType%5D=eq&searchCriteria%5BpageSize%5D=50&searchCriteria%5BcurrentPage%5D=1" -H "accept: application/json" -H "Authorization: Bearer $admin_token" | json_pp

Get the value for sortOrder attribute

While this value doesn't make any difference for Web API agents it may impact on the user interface for admin user. In this tutorial, we will show you how to place the input for the attribute selection in the right place.

We want to specify the Size right after the Price. To find the correct sortOrder we will execute 2 queries to the database The first one, will expose the attribute_id for the price attribute:

mysql -uroot -p -e'SELECT attribute_id FROM msi.eav_attribute WHERE attribute_code="price"'

The result:

+--------------+
| attribute_id |
+--------------+
|           77 |
+--------------+

The second one, will give us will expose the sortOrder for price attribute:

mysql -uroot -p -e'SELECT sort_order FROM msi.eav_entity_attribute WHERE attribute_id=77 && attribute_set_id = 9'

The result:

+------------+
| sort_order |
+------------+
|         30 |
+------------+