[VBA][Excel] Using the ebayAPI, send a request with the Category ID. Then get each Item Specifics and its recommended value.
Budget: $30 – $250 USD
Hello,
I do not speak English at all, so communication will be by message only.
Very briefly, let me describe the request.
What we would like you to do is to create a program that sends a request with a category ID and get all Item Specifics and recommended values for that category.
If you are familiar with eBay's API, this is an easy job that should take less than a day.
However, I am unable to provide an application key, so I am looking for someone who has one and can debug.
After I receive the code, I will run it in Excel on my PC and pay you for the results.
So please do not use any special libraries or anything like that.
Just copy-paste the code and have it ready to use.
eBayAPI does not have enough information for development, and many people quit the job in the middle of the project.
Therefore, we will give preference to people with eBayAPI experience.
I do not know eBay API at all, but I found the following information on the Internet.
Perhaps this API will give me the results I want.
[GetCategorySpecificsResponseType].
https://www.edp.ebay.com/DevZone/XML/docs/Reference/eBay/types/GetCategorySpecificsResponseType.html
I am not sure if this can be used in VBA.
Any other method would be fine as long as you can get the results.
-Specifics
It is easier to understand the content after reading the URL link.
Send a request from VBA with eBay's API.
Include the category ID in the request.
The goal is to get all Item Specifics for the category corresponding to the category ID and their recommended values.
The rough image of the final result is shown in the image.
For example, the code might look something like this
sub getItemSpecifics Value()
Dim Header_and_Val() as String
'Use eBay's API here to store the values in an array
Range(Cells(1, 1), Cells(Ubound(Header_and_Val, 2), Ubound(Header_and_Val, 1)) = Header_and_Val
End Sub
Prepare a two-dimensional array, storing the header information in the first row and the recommended values for the items starting from the second row.
As noted on the URL link page, if there are multiple values, the item specification most relevant to the category is returned first.
The same is true for the recommended values of Item Specifics.
Store them in the array in that order.
For required Item Specifics, a value such as "Required" is returned.
In such cases, prefix the header name in the array with *.
Thank you!
I do not speak English at all, so communication will be by message only.
Very briefly, let me describe the request.
What we would like you to do is to create a program that sends a request with a category ID and get all Item Specifics and recommended values for that category.
If you are familiar with eBay's API, this is an easy job that should take less than a day.
However, I am unable to provide an application key, so I am looking for someone who has one and can debug.
After I receive the code, I will run it in Excel on my PC and pay you for the results.
So please do not use any special libraries or anything like that.
Just copy-paste the code and have it ready to use.
eBayAPI does not have enough information for development, and many people quit the job in the middle of the project.
Therefore, we will give preference to people with eBayAPI experience.
I do not know eBay API at all, but I found the following information on the Internet.
Perhaps this API will give me the results I want.
[GetCategorySpecificsResponseType].
https://www.edp.ebay.com/DevZone/XML/docs/Reference/eBay/types/GetCategorySpecificsResponseType.html
I am not sure if this can be used in VBA.
Any other method would be fine as long as you can get the results.
-Specifics
It is easier to understand the content after reading the URL link.
Send a request from VBA with eBay's API.
Include the category ID in the request.
The goal is to get all Item Specifics for the category corresponding to the category ID and their recommended values.
The rough image of the final result is shown in the image.
For example, the code might look something like this
sub getItemSpecifics Value()
Dim Header_and_Val() as String
'Use eBay's API here to store the values in an array
Range(Cells(1, 1), Cells(Ubound(Header_and_Val, 2), Ubound(Header_and_Val, 1)) = Header_and_Val
End Sub
Prepare a two-dimensional array, storing the header information in the first row and the recommended values for the items starting from the second row.
As noted on the URL link page, if there are multiple values, the item specification most relevant to the category is returned first.
The same is true for the recommended values of Item Specifics.
Store them in the array in that order.
For required Item Specifics, a value such as "Required" is returned.
In such cases, prefix the header name in the array with *.
Thank you!