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 ChilkatHttp
Dim success As Long
http.BasicAuth = 1
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 GetShippingOptionsOnVariant(\n\t$id: ID!\n\t$pageSize: Int\n\t$endCursor: String\n\t$soEndCursor: String\n\t$srEndCursor: String\n\t$szEndCursor: String\n) {\n\tnode(id: $id) {\n\t\t... on Advert {\n\t\t\tid\n\t\t\tlegacyId\n\t\t\ttitle\n\n\t\t\tvariants(displayableOnly: false, first: $pageSize, after: $endCursor) {\n\t\t\t\tnodes {\n\t\t\t\t\tid\n\t\t\t\t\tlegacyId\n\t\t\t\t\tlabel\n\t\t\t\t\tshippingOptions(first: $pageSize, after: $soEndCursor) {\n\t\t\t\t\t\ttotalCount\n\t\t\t\t\t\tpageInfo {\n\t\t\t\t\t\t\t...PageInfoPartial\n\t\t\t\t\t\t}\n\t\t\t\t\t\tedges {\n\t\t\t\t\t\t\tnode {\n\t\t\t\t\t\t\t\tid\n\t\t\t\t\t\t\t\tname\n\t\t\t\t\t\t\t\tshippingRates(first: $pageSize, after: $srEndCursor) {\n\t\t\t\t\t\t\t\t\ttotalCount\n\t\t\t\t\t\t\t\t\tpageInfo {\n\t\t\t\t\t\t\t\t\t\t...PageInfoPartial\n\t\t\t\t\t\t\t\t\t}\n\t\t\t\t\t\t\t\t\tedges {\n\t\t\t\t\t\t\t\t\t\tnode {\n\t\t\t\t\t\t\t\t\t\t\tname\n\t\t\t\t\t\t\t\t\t\t\trateCents\n\t\t\t\t\t\t\t\t\t\t}\n\t\t\t\t\t\t\t\t\t}\n\t\t\t\t\t\t\t\t}\n\t\t\t\t\t\t\t\tshippingZones(first: $pageSize, after: $szEndCursor) {\n\t\t\t\t\t\t\t\t\ttotalCount\n\t\t\t\t\t\t\t\t\tpageInfo {\n\t\t\t\t\t\t\t\t\t\t...PageInfoPartial\n\t\t\t\t\t\t\t\t\t}\n\t\t\t\t\t\t\t\t\tedges {\n\t\t\t\t\t\t\t\t\t\tnode {\n\t\t\t\t\t\t\t\t\t\t\tname\n\t\t\t\t\t\t\t\t\t\t\tpostcodes\n\t\t\t\t\t\t\t\t\t\t}\n\t\t\t\t\t\t\t\t\t}\n\t\t\t\t\t\t\t\t}\n\t\t\t\t\t\t\t}\n\t\t\t\t\t\t}\n\t\t\t\t\t}\n\t\t\t\t}\n\t\t\t\tpageInfo {\n\t\t\t\t\t...PageInfoPartial\n\t\t\t\t}\n\t\t\t}\n\t\t}\n\t}\n}\n\nfragment PageInfoPartial on PageInfo {\n\thasNextPage\n\tendCursor\n}",
' "variables": "{\n \"id\": \"QWR2ZXJ0LTEwMDA5MjkwNw==\",\n \"pageSize\": 5,\n \"endCursor\": null,\n \"soEndCursor\": null,\n \"srEndCursor\": null,\n \"szEndCursor\": null\n}"
' }
Dim json As New ChilkatJsonObject
success = json.UpdateString("query","query GetShippingOptionsOnVariant(" & vbLf & " $id: ID!" & vbLf & " $pageSize: Int" & vbLf & " $endCursor: String" & vbLf & " $soEndCursor: String" & vbLf & " $srEndCursor: String" & vbLf & " $szEndCursor: String" & vbLf & ") {" & vbLf & " node(id: $id) {" & vbLf & " ... on Advert {" & vbLf & " id" & vbLf & " legacyId" & vbLf & " title" & vbLf & vbLf & " variants(displayableOnly: false, first: $pageSize, after: $endCursor) {" & vbLf & " nodes {" & vbLf & " id" & vbLf & " legacyId" & vbLf & " label" & vbLf & " shippingOptions(first: $pageSize, after: $soEndCursor) {" & vbLf & " totalCount" & vbLf & " pageInfo {" & vbLf & " ...PageInfoPartial" & vbLf & " }" & vbLf & " edges {" & vbLf & " node {" & vbLf & " id" & vbLf & " name" & vbLf & " shippingRates(first: $pageSize, after: $srEndCursor) {" & vbLf & " totalCount" & vbLf & " pageInfo {" & vbLf & " ...PageInfoPartial" & vbLf & " }" & vbLf & " edges {" & vbLf & " node {" & vbLf & " name" & vbLf & " rateCents" & vbLf & " }" & vbLf & " }" & vbLf & " }" & vbLf & " shippingZones(first: $pageSize, after: $szEndCursor) {" & vbLf & " totalCount" & vbLf & " pageInfo {" & vbLf & " ...PageInfoPartial" & vbLf & " }" & vbLf & " edges {" & vbLf & " node {" & vbLf & " name" & vbLf & " postcodes" & vbLf & " }" & vbLf & " }" & vbLf & " }" & vbLf & " }" & vbLf & " }" & vbLf & " }" & vbLf & " }" & vbLf & " pageInfo {" & vbLf & " ...PageInfoPartial" & vbLf & " }" & vbLf & " }" & vbLf & " }" & vbLf & " }" & vbLf & "}" & vbLf & vbLf & "fragment PageInfoPartial on PageInfo {" & vbLf & " hasNextPage" & vbLf & " endCursor" & vbLf & "}")
success = json.UpdateString("variables","{" & vbLf & " ""id"": ""QWR2ZXJ0LTEwMDA5MjkwNw==""," & vbLf & " ""pageSize"": 5," & vbLf & " ""endCursor"": null," & vbLf & " ""soEndCursor"": null," & vbLf & " ""srEndCursor"": null," & vbLf & " ""szEndCursor"": null" & vbLf & "}")
http.SetRequestHeader "Content-Type","application/json"
http.SetRequestHeader "MARKETPLACER-API-KEY","{{api_key}}"
Dim resp As ChilkatHttpResponse
Set resp = http.PostJson3("https://bestfriendbazaar.com/graphql","application/json",json)
If (http.LastMethodSuccess = 0) Then
Debug.Print http.LastErrorText
Exit Sub
End If
Debug.Print resp.StatusCode
Debug.Print 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 GetShippingOptionsOnVariant(\n\t$id: ID!\n\t$pageSize: Int\n\t$endCursor: String\n\t$soEndCursor: String\n\t$srEndCursor: String\n\t$szEndCursor: String\n) {\n\tnode(id: $id) {\n\t\t... on Advert {\n\t\t\tid\n\t\t\tlegacyId\n\t\t\ttitle\n\n\t\t\tvariants(displayableOnly: false, first: $pageSize, after: $endCursor) {\n\t\t\t\tnodes {\n\t\t\t\t\tid\n\t\t\t\t\tlegacyId\n\t\t\t\t\tlabel\n\t\t\t\t\tshippingOptions(first: $pageSize, after: $soEndCursor) {\n\t\t\t\t\t\ttotalCount\n\t\t\t\t\t\tpageInfo {\n\t\t\t\t\t\t\t...PageInfoPartial\n\t\t\t\t\t\t}\n\t\t\t\t\t\tedges {\n\t\t\t\t\t\t\tnode {\n\t\t\t\t\t\t\t\tid\n\t\t\t\t\t\t\t\tname\n\t\t\t\t\t\t\t\tshippingRates(first: $pageSize, after: $srEndCursor) {\n\t\t\t\t\t\t\t\t\ttotalCount\n\t\t\t\t\t\t\t\t\tpageInfo {\n\t\t\t\t\t\t\t\t\t\t...PageInfoPartial\n\t\t\t\t\t\t\t\t\t}\n\t\t\t\t\t\t\t\t\tedges {\n\t\t\t\t\t\t\t\t\t\tnode {\n\t\t\t\t\t\t\t\t\t\t\tname\n\t\t\t\t\t\t\t\t\t\t\trateCents\n\t\t\t\t\t\t\t\t\t\t}\n\t\t\t\t\t\t\t\t\t}\n\t\t\t\t\t\t\t\t}\n\t\t\t\t\t\t\t\tshippingZones(first: $pageSize, after: $szEndCursor) {\n\t\t\t\t\t\t\t\t\ttotalCount\n\t\t\t\t\t\t\t\t\tpageInfo {\n\t\t\t\t\t\t\t\t\t\t...PageInfoPartial\n\t\t\t\t\t\t\t\t\t}\n\t\t\t\t\t\t\t\t\tedges {\n\t\t\t\t\t\t\t\t\t\tnode {\n\t\t\t\t\t\t\t\t\t\t\tname\n\t\t\t\t\t\t\t\t\t\t\tpostcodes\n\t\t\t\t\t\t\t\t\t\t}\n\t\t\t\t\t\t\t\t\t}\n\t\t\t\t\t\t\t\t}\n\t\t\t\t\t\t\t}\n\t\t\t\t\t\t}\n\t\t\t\t\t}\n\t\t\t\t}\n\t\t\t\tpageInfo {\n\t\t\t\t\t...PageInfoPartial\n\t\t\t\t}\n\t\t\t}\n\t\t}\n\t}\n}\n\nfragment PageInfoPartial on PageInfo {\n\thasNextPage\n\tendCursor\n}","variables":"{\n \"id\": \"QWR2ZXJ0LTEwMDA5MjkwNw==\",\n \"pageSize\": 5,\n \"endCursor\": null,\n \"soEndCursor\": null,\n \"srEndCursor\": null,\n \"szEndCursor\": null\n}"}'
https://bestfriendbazaar.com/graphql
Postman Collection Item JSON
{
"name": "Get Shipping Options on Variant",
"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 GetShippingOptionsOnVariant(\n\t$id: ID!\n\t$pageSize: Int\n\t$endCursor: String\n\t$soEndCursor: String\n\t$srEndCursor: String\n\t$szEndCursor: String\n) {\n\tnode(id: $id) {\n\t\t... on Advert {\n\t\t\tid\n\t\t\tlegacyId\n\t\t\ttitle\n\n\t\t\tvariants(displayableOnly: false, first: $pageSize, after: $endCursor) {\n\t\t\t\tnodes {\n\t\t\t\t\tid\n\t\t\t\t\tlegacyId\n\t\t\t\t\tlabel\n\t\t\t\t\tshippingOptions(first: $pageSize, after: $soEndCursor) {\n\t\t\t\t\t\ttotalCount\n\t\t\t\t\t\tpageInfo {\n\t\t\t\t\t\t\t...PageInfoPartial\n\t\t\t\t\t\t}\n\t\t\t\t\t\tedges {\n\t\t\t\t\t\t\tnode {\n\t\t\t\t\t\t\t\tid\n\t\t\t\t\t\t\t\tname\n\t\t\t\t\t\t\t\tshippingRates(first: $pageSize, after: $srEndCursor) {\n\t\t\t\t\t\t\t\t\ttotalCount\n\t\t\t\t\t\t\t\t\tpageInfo {\n\t\t\t\t\t\t\t\t\t\t...PageInfoPartial\n\t\t\t\t\t\t\t\t\t}\n\t\t\t\t\t\t\t\t\tedges {\n\t\t\t\t\t\t\t\t\t\tnode {\n\t\t\t\t\t\t\t\t\t\t\tname\n\t\t\t\t\t\t\t\t\t\t\trateCents\n\t\t\t\t\t\t\t\t\t\t}\n\t\t\t\t\t\t\t\t\t}\n\t\t\t\t\t\t\t\t}\n\t\t\t\t\t\t\t\tshippingZones(first: $pageSize, after: $szEndCursor) {\n\t\t\t\t\t\t\t\t\ttotalCount\n\t\t\t\t\t\t\t\t\tpageInfo {\n\t\t\t\t\t\t\t\t\t\t...PageInfoPartial\n\t\t\t\t\t\t\t\t\t}\n\t\t\t\t\t\t\t\t\tedges {\n\t\t\t\t\t\t\t\t\t\tnode {\n\t\t\t\t\t\t\t\t\t\t\tname\n\t\t\t\t\t\t\t\t\t\t\tpostcodes\n\t\t\t\t\t\t\t\t\t\t}\n\t\t\t\t\t\t\t\t\t}\n\t\t\t\t\t\t\t\t}\n\t\t\t\t\t\t\t}\n\t\t\t\t\t\t}\n\t\t\t\t\t}\n\t\t\t\t}\n\t\t\t\tpageInfo {\n\t\t\t\t\t...PageInfoPartial\n\t\t\t\t}\n\t\t\t}\n\t\t}\n\t}\n}\n\nfragment PageInfoPartial on PageInfo {\n\thasNextPage\n\tendCursor\n}",
"variables": "{\n \"id\": \"QWR2ZXJ0LTEwMDA5MjkwNw==\",\n \"pageSize\": 5,\n \"endCursor\": null,\n \"soEndCursor\": null,\n \"srEndCursor\": null,\n \"szEndCursor\": null\n}"
}
},
"url": {
"raw": "{{base_url}}",
"host": [
"{{base_url}}"
],
"path": null
},
"description": null
},
"response": [
]
}
