Chilkat Online Tools

VB6 / Marketplacer SELLER API / Get Refund Requests Updated Since

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 GetRefundRequestsUpdatedSince\n($pageSize: Int $endCursor: String $updatedSince: ISO8601DateTime!)\n{\n  updatedRefundRequests\n\t(\n\t\tupdatedSince: $updatedSince\n\t\tfirst: $pageSize\n\t\tafter: $endCursor\n\t\n\t)\n  {\n    edges{\n      node{\n        id\n        status\n        cashAmountCents\n        createdAt\n        refundedAt\n        updatedAt\n        giftCardAmountCents\n        recoveredAmountCents\n        refundAmountCents\n        totalCents\n        initiatedBy\n        invoice{\n          id\n        }\n        lineItems{\n          id\n          amountCents\n          amountPerItemCents\n          onlyRemittance\n          quantity\n          reason \n        }\n      }  \n    }\n\t\tpageInfo{\n\t\t\thasNextPage\n\t\t\tendCursor\n\t\t}\n  }\n}",
'   "variables": "{\n  \"pageSize\": 50,\n  \"endCursor\": \"\",\n  \"updatedSince\": \"2021-08-05\"\n}"
' }

Dim json As New ChilkatJsonObject
success = json.UpdateString("query","query GetRefundRequestsUpdatedSince" & vbLf & "($pageSize: Int $endCursor: String $updatedSince: ISO8601DateTime!)" & vbLf & "{" & vbLf & "  updatedRefundRequests" & vbLf & "	(" & vbLf & "		updatedSince: $updatedSince" & vbLf & "		first: $pageSize" & vbLf & "		after: $endCursor" & vbLf & "	" & vbLf & "	)" & vbLf & "  {" & vbLf & "    edges{" & vbLf & "      node{" & vbLf & "        id" & vbLf & "        status" & vbLf & "        cashAmountCents" & vbLf & "        createdAt" & vbLf & "        refundedAt" & vbLf & "        updatedAt" & vbLf & "        giftCardAmountCents" & vbLf & "        recoveredAmountCents" & vbLf & "        refundAmountCents" & vbLf & "        totalCents" & vbLf & "        initiatedBy" & vbLf & "        invoice{" & vbLf & "          id" & vbLf & "        }" & vbLf & "        lineItems{" & vbLf & "          id" & vbLf & "          amountCents" & vbLf & "          amountPerItemCents" & vbLf & "          onlyRemittance" & vbLf & "          quantity" & vbLf & "          reason " & vbLf & "        }" & vbLf & "      }  " & vbLf & "    }" & vbLf & "		pageInfo{" & vbLf & "			hasNextPage" & vbLf & "			endCursor" & vbLf & "		}" & vbLf & "  }" & vbLf & "}")
success = json.UpdateString("variables","{" & vbLf & "  ""pageSize"": 50," & vbLf & "  ""endCursor"": """"," & vbLf & "  ""updatedSince"": ""2021-08-05\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 GetRefundRequestsUpdatedSince\n($pageSize: Int $endCursor: String $updatedSince: ISO8601DateTime!)\n{\n  updatedRefundRequests\n\t(\n\t\tupdatedSince: $updatedSince\n\t\tfirst: $pageSize\n\t\tafter: $endCursor\n\t\n\t)\n  {\n    edges{\n      node{\n        id\n        status\n        cashAmountCents\n        createdAt\n        refundedAt\n        updatedAt\n        giftCardAmountCents\n        recoveredAmountCents\n        refundAmountCents\n        totalCents\n        initiatedBy\n        invoice{\n          id\n        }\n        lineItems{\n          id\n          amountCents\n          amountPerItemCents\n          onlyRemittance\n          quantity\n          reason \n        }\n      }  \n    }\n\t\tpageInfo{\n\t\t\thasNextPage\n\t\t\tendCursor\n\t\t}\n  }\n}","variables":"{\n  \"pageSize\": 50,\n  \"endCursor\": \"\",\n  \"updatedSince\": \"2021-08-05\"\n}"}'
https://bestfriendbazaar.com/graphql

Postman Collection Item JSON

{
  "name": "Get Refund Requests Updated Since",
  "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 GetRefundRequestsUpdatedSince\n($pageSize: Int $endCursor: String $updatedSince: ISO8601DateTime!)\n{\n  updatedRefundRequests\n\t(\n\t\tupdatedSince: $updatedSince\n\t\tfirst: $pageSize\n\t\tafter: $endCursor\n\t\n\t)\n  {\n    edges{\n      node{\n        id\n        status\n        cashAmountCents\n        createdAt\n        refundedAt\n        updatedAt\n        giftCardAmountCents\n        recoveredAmountCents\n        refundAmountCents\n        totalCents\n        initiatedBy\n        invoice{\n          id\n        }\n        lineItems{\n          id\n          amountCents\n          amountPerItemCents\n          onlyRemittance\n          quantity\n          reason \n        }\n      }  \n    }\n\t\tpageInfo{\n\t\t\thasNextPage\n\t\t\tendCursor\n\t\t}\n  }\n}",
        "variables": "{\n  \"pageSize\": 50,\n  \"endCursor\": \"\",\n  \"updatedSince\": \"2021-08-05\"\n}"
      }
    },
    "url": {
      "raw": "{{base_url}}",
      "host": [
        "{{base_url}}"
      ],
      "path": null
    },
    "description": null
  },
  "response": [
  ]
}