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 RemittanceAdvices(\n\t$pageSize: Int\n\t$endCursor: String\n\t$createdSince: ISO8601DateTime\n) {\n\tremittanceAdvices(\n\t\tfirst: $pageSize\n\t\tafter: $endCursor\n\t\tcreatedSince: $createdSince\n\t) {\n\t\tedges {\n\t\t\tnode {\n\t\t\t\t# Summary attributes that MKP Generats\n\t\t\t\ttotalCents\n\t\t\t\tcreatedAt\n\t\t\t\tid\n\t\t\t\tlegacyId\n\t\t\t\t# Summary attributes that can be updated by operator using remittanceAdviceUpdate\n\t\t\t\ttotalPaidCents\n\t\t\t\tpaidAt\n\t\t\t\tpaymentReference\n\t\t\t\tattachments {\n\t\t\t\t\tfilename\n\t\t\t\t}\n\t\t\t\t#seller\n\t\t\t\tseller {\n\t\t\t\t\tid\n\t\t\t\t}\n\t\t\t\t#remittances included in remittanceAdvice\n\t\t\t\tremittances {\n\t\t\t\t\tinvoice {\n\t\t\t\t\t\tid\n\t\t\t\t\t}\n\t\t\t\t\tinvoiceAmendment {\n\t\t\t\t\t\tid\n\t\t\t\t\t}\n\t\t\t\t}\n\t\t\t}\n\t\t}\n\t}\n}\n",
// "variables": "{\n \"pageSize\": 10,\n \"endCursor\": \"\",\n \"createdSince\": \"2022-02-02\"\n}"
// }
Dim json As New Chilkat.JsonObject
success = json.UpdateString("query","query RemittanceAdvices(" + EndOfLine.Unix + " $pageSize: Int" + EndOfLine.Unix + " $endCursor: String" + EndOfLine.Unix + " $createdSince: ISO8601DateTime" + EndOfLine.Unix + ") {" + EndOfLine.Unix + " remittanceAdvices(" + EndOfLine.Unix + " first: $pageSize" + EndOfLine.Unix + " after: $endCursor" + EndOfLine.Unix + " createdSince: $createdSince" + EndOfLine.Unix + " ) {" + EndOfLine.Unix + " edges {" + EndOfLine.Unix + " node {" + EndOfLine.Unix + " # Summary attributes that MKP Generats" + EndOfLine.Unix + " totalCents" + EndOfLine.Unix + " createdAt" + EndOfLine.Unix + " id" + EndOfLine.Unix + " legacyId" + EndOfLine.Unix + " # Summary attributes that can be updated by operator using remittanceAdviceUpdate" + EndOfLine.Unix + " totalPaidCents" + EndOfLine.Unix + " paidAt" + EndOfLine.Unix + " paymentReference" + EndOfLine.Unix + " attachments {" + EndOfLine.Unix + " filename" + EndOfLine.Unix + " }" + EndOfLine.Unix + " #seller" + EndOfLine.Unix + " seller {" + EndOfLine.Unix + " id" + EndOfLine.Unix + " }" + EndOfLine.Unix + " #remittances included in remittanceAdvice" + EndOfLine.Unix + " remittances {" + EndOfLine.Unix + " invoice {" + EndOfLine.Unix + " id" + EndOfLine.Unix + " }" + EndOfLine.Unix + " invoiceAmendment {" + EndOfLine.Unix + " id" + EndOfLine.Unix + " }" + EndOfLine.Unix + " }" + EndOfLine.Unix + " }" + EndOfLine.Unix + " }" + EndOfLine.Unix + " }" + EndOfLine.Unix + "}" + EndOfLine.Unix)
success = json.UpdateString("variables","{" + EndOfLine.Unix + " ""pageSize"": 10," + EndOfLine.Unix + " ""endCursor"": """"," + EndOfLine.Unix + " ""createdSince"": ""2022-02-02\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 RemittanceAdvices(\n\t$pageSize: Int\n\t$endCursor: String\n\t$createdSince: ISO8601DateTime\n) {\n\tremittanceAdvices(\n\t\tfirst: $pageSize\n\t\tafter: $endCursor\n\t\tcreatedSince: $createdSince\n\t) {\n\t\tedges {\n\t\t\tnode {\n\t\t\t\t# Summary attributes that MKP Generats\n\t\t\t\ttotalCents\n\t\t\t\tcreatedAt\n\t\t\t\tid\n\t\t\t\tlegacyId\n\t\t\t\t# Summary attributes that can be updated by operator using remittanceAdviceUpdate\n\t\t\t\ttotalPaidCents\n\t\t\t\tpaidAt\n\t\t\t\tpaymentReference\n\t\t\t\tattachments {\n\t\t\t\t\tfilename\n\t\t\t\t}\n\t\t\t\t#seller\n\t\t\t\tseller {\n\t\t\t\t\tid\n\t\t\t\t}\n\t\t\t\t#remittances included in remittanceAdvice\n\t\t\t\tremittances {\n\t\t\t\t\tinvoice {\n\t\t\t\t\t\tid\n\t\t\t\t\t}\n\t\t\t\t\tinvoiceAmendment {\n\t\t\t\t\t\tid\n\t\t\t\t\t}\n\t\t\t\t}\n\t\t\t}\n\t\t}\n\t}\n}\n","variables":"{\n \"pageSize\": 10,\n \"endCursor\": \"\",\n \"createdSince\": \"2022-02-02\"\n}"}'
https://bestfriendbazaar.com/graphql
Postman Collection Item JSON
{
"name": "Remittance Advices",
"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 RemittanceAdvices(\n\t$pageSize: Int\n\t$endCursor: String\n\t$createdSince: ISO8601DateTime\n) {\n\tremittanceAdvices(\n\t\tfirst: $pageSize\n\t\tafter: $endCursor\n\t\tcreatedSince: $createdSince\n\t) {\n\t\tedges {\n\t\t\tnode {\n\t\t\t\t# Summary attributes that MKP Generats\n\t\t\t\ttotalCents\n\t\t\t\tcreatedAt\n\t\t\t\tid\n\t\t\t\tlegacyId\n\t\t\t\t# Summary attributes that can be updated by operator using remittanceAdviceUpdate\n\t\t\t\ttotalPaidCents\n\t\t\t\tpaidAt\n\t\t\t\tpaymentReference\n\t\t\t\tattachments {\n\t\t\t\t\tfilename\n\t\t\t\t}\n\t\t\t\t#seller\n\t\t\t\tseller {\n\t\t\t\t\tid\n\t\t\t\t}\n\t\t\t\t#remittances included in remittanceAdvice\n\t\t\t\tremittances {\n\t\t\t\t\tinvoice {\n\t\t\t\t\t\tid\n\t\t\t\t\t}\n\t\t\t\t\tinvoiceAmendment {\n\t\t\t\t\t\tid\n\t\t\t\t\t}\n\t\t\t\t}\n\t\t\t}\n\t\t}\n\t}\n}\n",
"variables": "{\n \"pageSize\": 10,\n \"endCursor\": \"\",\n \"createdSince\": \"2022-02-02\"\n}"
}
},
"url": {
"raw": "{{base_url}}",
"host": [
"{{base_url}}"
],
"path": null
},
"description": null
},
"response": [
]
}