Chilkat Online Tools

VBScript / Marketplacer SELLER API / Query Refund Requests with Filters

Back to Collection Items

Dim fso, outFile
Set fso = CreateObject("Scripting.FileSystemObject")
'Create a Unicode (utf-16) output text file.
Set outFile = fso.CreateTextFile("output.txt", True, True)

' This example assumes the Chilkat API to have been previously unlocked.
' See Global Unlock Sample for sample code.

' For versions of Chilkat < 10.0.0, use CreateObject("Chilkat_9_5_0.Http")
set http = CreateObject("Chilkat.Http")

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 QueryRefundRequestsWithFilters ($pageSize: Int $endCursor: String $filters: RefundRequestFilters){\n\trefundRequests(filters: $filters first: $pageSize after: $endCursor) {\n\t\tedges {\n\t\t\tnode {\n\t\t\t\tstatus\n\t\t\t\tid\n\t\t\t\tlegacyId\n\t\t\t\tinvoice {\n\t\t\t\t\tlegacyId\n\t\t\t\t}\n\t\t\t\tlineItems {\n\t\t\t\t\tid\n\t\t\t\t\treason\n\t\t\t\t\tamountCents\n\t\t\t\t\tlineItem {\n\t\t\t\t\t\tid\n\t\t\t\t\t}\n\t\t\t\t\tonlyRemittance\n\t\t\t\t}\n\t\t\t}\n\t\t}\n\t\tpageInfo{\n\t\t\thasNextPage\n\t\t\tendCursor\n\t\t}\n\t}\n}",
'   "variables": "{\n  \"pageSize\": 100,\n  \"endCursor\": \"\",\n  \"filters\": {\n    \"statuses\": [\n      \"REFUNDED\",\n      \"PROCESSED\"\n    ],\n    \"buyerName\": \"Jackson\"\n  }\n}"
' }

' For versions of Chilkat < 10.0.0, use CreateObject("Chilkat_9_5_0.JsonObject")
set json = CreateObject("Chilkat.JsonObject")
success = json.UpdateString("query","query QueryRefundRequestsWithFilters ($pageSize: Int $endCursor: String $filters: RefundRequestFilters){" & vbLf & "	refundRequests(filters: $filters first: $pageSize after: $endCursor) {" & vbLf & "		edges {" & vbLf & "			node {" & vbLf & "				status" & vbLf & "				id" & vbLf & "				legacyId" & vbLf & "				invoice {" & vbLf & "					legacyId" & vbLf & "				}" & vbLf & "				lineItems {" & vbLf & "					id" & vbLf & "					reason" & vbLf & "					amountCents" & vbLf & "					lineItem {" & vbLf & "						id" & vbLf & "					}" & vbLf & "					onlyRemittance" & vbLf & "				}" & vbLf & "			}" & vbLf & "		}" & vbLf & "		pageInfo{" & vbLf & "			hasNextPage" & vbLf & "			endCursor" & vbLf & "		}" & vbLf & "	}" & vbLf & "}")
success = json.UpdateString("variables","{" & vbLf & "  ""pageSize"": 100," & vbLf & "  ""endCursor"": """"," & vbLf & "  ""filters"": {" & vbLf & "    ""statuses"": [" & vbLf & "      ""REFUNDED""," & vbLf & "      ""PROCESSED\vbLf & "    ]," & vbLf & "    ""buyerName"": ""Jackson\vbLf & "  }" & vbLf & "}")

http.SetRequestHeader "Content-Type","application/json"
http.SetRequestHeader "MARKETPLACER-API-KEY","{{api_key}}"

' resp is a Chilkat.HttpResponse
Set resp = http.PostJson3("https://bestfriendbazaar.com/graphql","application/json",json)
If (http.LastMethodSuccess = 0) Then
    outFile.WriteLine(http.LastErrorText)
    WScript.Quit
End If

outFile.WriteLine(resp.StatusCode)
outFile.WriteLine(resp.BodyStr)


outFile.Close

Curl Command

curl -X POST
	-u '{{username}}:{{password}}'
	-H "MARKETPLACER-API-KEY: {{api_key}}"
	-H "Content-Type: application/json"
	--data-raw '{"query":"query QueryRefundRequestsWithFilters ($pageSize: Int $endCursor: String $filters: RefundRequestFilters){\n\trefundRequests(filters: $filters first: $pageSize after: $endCursor) {\n\t\tedges {\n\t\t\tnode {\n\t\t\t\tstatus\n\t\t\t\tid\n\t\t\t\tlegacyId\n\t\t\t\tinvoice {\n\t\t\t\t\tlegacyId\n\t\t\t\t}\n\t\t\t\tlineItems {\n\t\t\t\t\tid\n\t\t\t\t\treason\n\t\t\t\t\tamountCents\n\t\t\t\t\tlineItem {\n\t\t\t\t\t\tid\n\t\t\t\t\t}\n\t\t\t\t\tonlyRemittance\n\t\t\t\t}\n\t\t\t}\n\t\t}\n\t\tpageInfo{\n\t\t\thasNextPage\n\t\t\tendCursor\n\t\t}\n\t}\n}","variables":"{\n  \"pageSize\": 100,\n  \"endCursor\": \"\",\n  \"filters\": {\n    \"statuses\": [\n      \"REFUNDED\",\n      \"PROCESSED\"\n    ],\n    \"buyerName\": \"Jackson\"\n  }\n}"}'
https://bestfriendbazaar.com/graphql

Postman Collection Item JSON

{
  "name": "Query Refund Requests with Filters",
  "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 QueryRefundRequestsWithFilters ($pageSize: Int $endCursor: String $filters: RefundRequestFilters){\n\trefundRequests(filters: $filters first: $pageSize after: $endCursor) {\n\t\tedges {\n\t\t\tnode {\n\t\t\t\tstatus\n\t\t\t\tid\n\t\t\t\tlegacyId\n\t\t\t\tinvoice {\n\t\t\t\t\tlegacyId\n\t\t\t\t}\n\t\t\t\tlineItems {\n\t\t\t\t\tid\n\t\t\t\t\treason\n\t\t\t\t\tamountCents\n\t\t\t\t\tlineItem {\n\t\t\t\t\t\tid\n\t\t\t\t\t}\n\t\t\t\t\tonlyRemittance\n\t\t\t\t}\n\t\t\t}\n\t\t}\n\t\tpageInfo{\n\t\t\thasNextPage\n\t\t\tendCursor\n\t\t}\n\t}\n}",
        "variables": "{\n  \"pageSize\": 100,\n  \"endCursor\": \"\",\n  \"filters\": {\n    \"statuses\": [\n      \"REFUNDED\",\n      \"PROCESSED\"\n    ],\n    \"buyerName\": \"Jackson\"\n  }\n}"
      }
    },
    "url": {
      "raw": "{{base_url}}",
      "host": [
        "{{base_url}}"
      ],
      "path": null
    },
    "description": null
  },
  "response": [
  ]
}