Xojo / Marketplacer SELLER API / allAdverts (Get Products by updated date)
Back to Collection Items
// This example assumes the Chilkat API to have been previously unlocked.
// See Global Unlock Sample for sample code.
Dim http As New Chilkat.Http
Dim success As Boolean
http.BasicAuth = True
http.Login = "{{username}}"
http.Password = "{{password}}"
// Use this online tool to generate code from sample JSON: Generate Code to Create JSON
// The following JSON is sent in the request body.
// {
// "query": "query AllProductsByUpdatedAtDate(\n\t$updatedSince: ISO8601DateTime\n\t$pageSize: Int\n\t$endCursor: String\n) {\n\tallAdverts(updatedSince: $updatedSince, first: $pageSize, after: $endCursor) {\n\t\tnodes {\n\t\t\t__typename\n\t\t\t... on Advert {\n\t\t\t\tid\n\t\t\t\ttitle\n\t\t\t\tupdatedAt\n\n\t\t\t\timages {\n\t\t\t\t\tnodes {\n\t\t\t\t\t\turl(width: 100, height: 100, fit: clip)\n\t\t\t\t\t}\n\t\t\t\t}\n\t\t\t\tvariants(displayableOnly: false, first: $pageSize) {\n\t\t\t\t\tnodes {\n\t\t\t\t\t\tid\n\t\t\t\t\t}\n\t\t\t\t\tpageInfo {\n\t\t\t\t\t\t...PageInfoPartial\n\t\t\t\t\t}\n\t\t\t\t}\n\t\t\t}\n\t\t\t... on UnpublishedAdvert {\n\t\t\t\tid\n\t\t\t\tupdatedAt\n\t\t\t\tvariants(first: $pageSize) {\n\t\t\t\t\tnodes {\n\t\t\t\t\t\tid\n\t\t\t\t\t}\n\t\t\t\t\tpageInfo {\n\t\t\t\t\t\t...PageInfoPartial\n\t\t\t\t\t}\n\t\t\t\t}\n\t\t\t\tdetails {\n\t\t\t\t\ttitle\n\t\t\t\t}\n\t\t\t}\n\t\t\t... on DeletedAdvert {\n\t\t\t\tid\n\t\t\t\tupdatedAt\n\t\t\t\tvariants(first: 5) {\n\t\t\t\t\tnodes {\n\t\t\t\t\t\tid\n\t\t\t\t\t}\n\t\t\t\t\tpageInfo {\n\t\t\t\t\t\t...PageInfoPartial\n\t\t\t\t\t}\n\t\t\t\t}\n\t\t\t}\n\t\t}\n\t\tpageInfo {\n\t\t\t...PageInfoPartial\n\t\t}\n\t}\n}\n\nfragment PageInfoPartial on PageInfo {\n\thasNextPage\n\tendCursor\n}",
// "variables": "{\n\t\"pageSize\": 50,\n\t\"endCursor\": null,\n\t\"updatedSince\": \"2023-11-30T09:05:57+11:00\"\n}"
// }
Dim json As New Chilkat.JsonObject
success = json.UpdateString("query","query AllProductsByUpdatedAtDate(" + EndOfLine.Unix + " $updatedSince: ISO8601DateTime" + EndOfLine.Unix + " $pageSize: Int" + EndOfLine.Unix + " $endCursor: String" + EndOfLine.Unix + ") {" + EndOfLine.Unix + " allAdverts(updatedSince: $updatedSince, first: $pageSize, after: $endCursor) {" + EndOfLine.Unix + " nodes {" + EndOfLine.Unix + " __typename" + EndOfLine.Unix + " ... on Advert {" + EndOfLine.Unix + " id" + EndOfLine.Unix + " title" + EndOfLine.Unix + " updatedAt" + EndOfLine.Unix + EndOfLine.Unix + " images {" + EndOfLine.Unix + " nodes {" + EndOfLine.Unix + " url(width: 100, height: 100, fit: clip)" + EndOfLine.Unix + " }" + EndOfLine.Unix + " }" + EndOfLine.Unix + " variants(displayableOnly: false, first: $pageSize) {" + EndOfLine.Unix + " nodes {" + EndOfLine.Unix + " id" + EndOfLine.Unix + " }" + EndOfLine.Unix + " pageInfo {" + EndOfLine.Unix + " ...PageInfoPartial" + EndOfLine.Unix + " }" + EndOfLine.Unix + " }" + EndOfLine.Unix + " }" + EndOfLine.Unix + " ... on UnpublishedAdvert {" + EndOfLine.Unix + " id" + EndOfLine.Unix + " updatedAt" + EndOfLine.Unix + " variants(first: $pageSize) {" + EndOfLine.Unix + " nodes {" + EndOfLine.Unix + " id" + EndOfLine.Unix + " }" + EndOfLine.Unix + " pageInfo {" + EndOfLine.Unix + " ...PageInfoPartial" + EndOfLine.Unix + " }" + EndOfLine.Unix + " }" + EndOfLine.Unix + " details {" + EndOfLine.Unix + " title" + EndOfLine.Unix + " }" + EndOfLine.Unix + " }" + EndOfLine.Unix + " ... on DeletedAdvert {" + EndOfLine.Unix + " id" + EndOfLine.Unix + " updatedAt" + EndOfLine.Unix + " variants(first: 5) {" + EndOfLine.Unix + " nodes {" + EndOfLine.Unix + " id" + EndOfLine.Unix + " }" + EndOfLine.Unix + " pageInfo {" + EndOfLine.Unix + " ...PageInfoPartial" + EndOfLine.Unix + " }" + EndOfLine.Unix + " }" + EndOfLine.Unix + " }" + EndOfLine.Unix + " }" + EndOfLine.Unix + " pageInfo {" + EndOfLine.Unix + " ...PageInfoPartial" + EndOfLine.Unix + " }" + EndOfLine.Unix + " }" + EndOfLine.Unix + "}" + EndOfLine.Unix + EndOfLine.Unix + "fragment PageInfoPartial on PageInfo {" + EndOfLine.Unix + " hasNextPage" + EndOfLine.Unix + " endCursor" + EndOfLine.Unix + "}")
success = json.UpdateString("variables","{" + EndOfLine.Unix + " ""pageSize"": 50," + EndOfLine.Unix + " ""endCursor"": null," + EndOfLine.Unix + " ""updatedSince"": ""2023-11-30T09:05:57+11:00\EndOfLine.Unix + "}")
http.SetRequestHeader "Content-Type","application/json"
http.SetRequestHeader "MARKETPLACER-API-KEY","{{api_key}}"
Dim resp As Chilkat.HttpResponse
resp = http.PostJson3("https://bestfriendbazaar.com/graphql","application/json",json)
If (http.LastMethodSuccess = False) Then
System.DebugLog(http.LastErrorText)
Return
End If
System.DebugLog(Str(resp.StatusCode))
System.DebugLog(resp.BodyStr)
Curl Command
curl -X POST
-u '{{username}}:{{password}}'
-H "MARKETPLACER-API-KEY: {{api_key}}"
-H "Content-Type: application/json"
--data-raw '{"query":"query AllProductsByUpdatedAtDate(\n\t$updatedSince: ISO8601DateTime\n\t$pageSize: Int\n\t$endCursor: String\n) {\n\tallAdverts(updatedSince: $updatedSince, first: $pageSize, after: $endCursor) {\n\t\tnodes {\n\t\t\t__typename\n\t\t\t... on Advert {\n\t\t\t\tid\n\t\t\t\ttitle\n\t\t\t\tupdatedAt\n\n\t\t\t\timages {\n\t\t\t\t\tnodes {\n\t\t\t\t\t\turl(width: 100, height: 100, fit: clip)\n\t\t\t\t\t}\n\t\t\t\t}\n\t\t\t\tvariants(displayableOnly: false, first: $pageSize) {\n\t\t\t\t\tnodes {\n\t\t\t\t\t\tid\n\t\t\t\t\t}\n\t\t\t\t\tpageInfo {\n\t\t\t\t\t\t...PageInfoPartial\n\t\t\t\t\t}\n\t\t\t\t}\n\t\t\t}\n\t\t\t... on UnpublishedAdvert {\n\t\t\t\tid\n\t\t\t\tupdatedAt\n\t\t\t\tvariants(first: $pageSize) {\n\t\t\t\t\tnodes {\n\t\t\t\t\t\tid\n\t\t\t\t\t}\n\t\t\t\t\tpageInfo {\n\t\t\t\t\t\t...PageInfoPartial\n\t\t\t\t\t}\n\t\t\t\t}\n\t\t\t\tdetails {\n\t\t\t\t\ttitle\n\t\t\t\t}\n\t\t\t}\n\t\t\t... on DeletedAdvert {\n\t\t\t\tid\n\t\t\t\tupdatedAt\n\t\t\t\tvariants(first: 5) {\n\t\t\t\t\tnodes {\n\t\t\t\t\t\tid\n\t\t\t\t\t}\n\t\t\t\t\tpageInfo {\n\t\t\t\t\t\t...PageInfoPartial\n\t\t\t\t\t}\n\t\t\t\t}\n\t\t\t}\n\t\t}\n\t\tpageInfo {\n\t\t\t...PageInfoPartial\n\t\t}\n\t}\n}\n\nfragment PageInfoPartial on PageInfo {\n\thasNextPage\n\tendCursor\n}","variables":"{\n\t\"pageSize\": 50,\n\t\"endCursor\": null,\n\t\"updatedSince\": \"2023-11-30T09:05:57+11:00\"\n}"}'
https://bestfriendbazaar.com/graphql
Postman Collection Item JSON
{
"name": "allAdverts (Get Products by updated date)",
"request": {
"method": "POST",
"header": [
{
"key": "MARKETPLACER-API-KEY",
"value": "{{api_key}}",
"type": "text"
},
{
"key": "Content-Type",
"value": "application/json",
"type": "text"
}
],
"body": {
"mode": "graphql",
"graphql": {
"query": "query AllProductsByUpdatedAtDate(\n\t$updatedSince: ISO8601DateTime\n\t$pageSize: Int\n\t$endCursor: String\n) {\n\tallAdverts(updatedSince: $updatedSince, first: $pageSize, after: $endCursor) {\n\t\tnodes {\n\t\t\t__typename\n\t\t\t... on Advert {\n\t\t\t\tid\n\t\t\t\ttitle\n\t\t\t\tupdatedAt\n\n\t\t\t\timages {\n\t\t\t\t\tnodes {\n\t\t\t\t\t\turl(width: 100, height: 100, fit: clip)\n\t\t\t\t\t}\n\t\t\t\t}\n\t\t\t\tvariants(displayableOnly: false, first: $pageSize) {\n\t\t\t\t\tnodes {\n\t\t\t\t\t\tid\n\t\t\t\t\t}\n\t\t\t\t\tpageInfo {\n\t\t\t\t\t\t...PageInfoPartial\n\t\t\t\t\t}\n\t\t\t\t}\n\t\t\t}\n\t\t\t... on UnpublishedAdvert {\n\t\t\t\tid\n\t\t\t\tupdatedAt\n\t\t\t\tvariants(first: $pageSize) {\n\t\t\t\t\tnodes {\n\t\t\t\t\t\tid\n\t\t\t\t\t}\n\t\t\t\t\tpageInfo {\n\t\t\t\t\t\t...PageInfoPartial\n\t\t\t\t\t}\n\t\t\t\t}\n\t\t\t\tdetails {\n\t\t\t\t\ttitle\n\t\t\t\t}\n\t\t\t}\n\t\t\t... on DeletedAdvert {\n\t\t\t\tid\n\t\t\t\tupdatedAt\n\t\t\t\tvariants(first: 5) {\n\t\t\t\t\tnodes {\n\t\t\t\t\t\tid\n\t\t\t\t\t}\n\t\t\t\t\tpageInfo {\n\t\t\t\t\t\t...PageInfoPartial\n\t\t\t\t\t}\n\t\t\t\t}\n\t\t\t}\n\t\t}\n\t\tpageInfo {\n\t\t\t...PageInfoPartial\n\t\t}\n\t}\n}\n\nfragment PageInfoPartial on PageInfo {\n\thasNextPage\n\tendCursor\n}",
"variables": "{\n\t\"pageSize\": 50,\n\t\"endCursor\": null,\n\t\"updatedSince\": \"2023-11-30T09:05:57+11:00\"\n}"
}
},
"url": {
"raw": "{{base_url}}",
"host": [
"{{base_url}}"
],
"path": null
},
"description": null
},
"response": [
]
}
