Foxpro / Marketplacer SELLER API / Remittances with Line Item Breakdown
Back to Collection Items
LOCAL loHttp
LOCAL lnSuccess
LOCAL loJson
LOCAL loResp
* This example assumes the Chilkat API to have been previously unlocked.
* See Global Unlock Sample for sample code.
loHttp = CreateObject('Chilkat.Http')
loHttp.BasicAuth = 1
loHttp.Login = "{{username}}"
loHttp.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 GetRemittancesWithLineItemBreakdown(\n\t$pageSize: Int\n\t$endCursor: String\n\t$createdSince: ISO8601DateTime\n) {\n\tremittances(\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\tamountCents\n\t\t\t\t#This section pulls in invoices based on their remited date\n\n\t\t\t\tinvoice {\n\t\t\t\t\tid\n\t\t\t\t\tlegacyId\n\t\t\t\t\tremittedAt\n\t\t\t\t\t#total remittance= totalCents-comissionAmountCents-merchantFeeCents-shippingCostCents-taxTotalCents\n\t\t\t\t\ttotalCents\n\t\t\t\t\tcommissionAmountCents\n\t\t\t\t\tmerchantFeeCents\n\t\t\t\t\tshippingCostCents\n\t\t\t\t\ttaxTotalCents\n\t\t\t\t\tlineItems {\n\t\t\t\t\t\tid\n\t\t\t\t\t\t#total remittance= totalCents-comissionAmountCent-postageCents-taxTotalCents\n\t\t\t\t\t\ttotalCents\n\t\t\t\t\t\titemAmountCents\n\t\t\t\t\t\tsubtotalCents\n\t\t\t\t\t\tcommissionAmountCents\n\t\t\t\t\t\tpostageCents\n\t\t\t\t\t\ttaxTotalCents\n\t\t\t\t\t}\n\t\t\t\t}\n\t\t\t\t#This section pulls in amendments based on their remited date\n\t\t\t\tinvoiceAmendment {\n\t\t\t\t\tid\n\t\t\t\t\tlegacyId\n\t\t\t\t\tremittedAt\n\t\t\t\t\ttotalCents\n\t\t\t\t\tremittanceCents\n\t\t\t\t\tlineItemAmountTotalCents\n\t\t\t\t\tlineItemTaxTotalCents\n\t\t\t\t\tcommissionAmountTotalCents\n\t\t\t\t\tcommissionTaxTotalCents\n\t\t\t\t\tremittanceAmountTotalCents\n\t\t\t\t\tremittanceTaxTotalCents\n\t\t\t\t\tlineItems {\n\t\t\t\t\t\tamountCents\n\t\t\t\t\t\ttaxCents\n\t\t\t\t\t\ttotalCents\n\t\t\t\t\t\tlineItemAmountCents\n\t\t\t\t\t\tlineItemTaxCents\n\t\t\t\t\t\tcommissionAmountCents\n\t\t\t\t\t\tcommissionTaxCents\n\t\t\t\t\t\tremittanceAmountCents\n\t\t\t\t\t\tremittanceTaxCents\n\t\t\t\t\t\tlineItem {\n\t\t\t\t\t\t\tid\n\t\t\t\t\t\t\titemAmountCents\n\t\t\t\t\t\t\ttaxTotalCents\n\t\t\t\t\t\t\texternalIds {\n\t\t\t\t\t\t\t\tkey\n\t\t\t\t\t\t\t\tvalue\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\t#this section pulls in the invoice the invoice ammendment is related to so operators could tie the amendments\n\t\t\t\t\tinvoice {\n\t\t\t\t\t\tlegacyId\n\t\t\t\t\t\tremittedAt\n\t\t\t\t\t}\n\t\t\t\t}\n\t\t\t}\n\t\t}\n\t}\n}\n",
* "variables": "{\n\t\"pageSize\": 50,\n\t\"endCursor\": \"\",\n\t\"createdSince\": \"2022-01-22T09:30:46-08:00\"\n}"
* }
loJson = CreateObject('Chilkat.JsonObject')
loJson.UpdateString("query","query GetRemittancesWithLineItemBreakdown(" + CHR(10) + " $pageSize: Int" + CHR(10) + " $endCursor: String" + CHR(10) + " $createdSince: ISO8601DateTime" + CHR(10) + ") {" + CHR(10) + " remittances(" + CHR(10) + " first: $pageSize" + CHR(10) + " after: $endCursor" + CHR(10) + " createdSince: $createdSince" + CHR(10) + " ) {" + CHR(10) + " edges {" + CHR(10) + " node {" + CHR(10) + " amountCents" + CHR(10) + " #This section pulls in invoices based on their remited date" + CHR(10) + CHR(10) + " invoice {" + CHR(10) + " id" + CHR(10) + " legacyId" + CHR(10) + " remittedAt" + CHR(10) + " #total remittance= totalCents-comissionAmountCents-merchantFeeCents-shippingCostCents-taxTotalCents" + CHR(10) + " totalCents" + CHR(10) + " commissionAmountCents" + CHR(10) + " merchantFeeCents" + CHR(10) + " shippingCostCents" + CHR(10) + " taxTotalCents" + CHR(10) + " lineItems {" + CHR(10) + " id" + CHR(10) + " #total remittance= totalCents-comissionAmountCent-postageCents-taxTotalCents" + CHR(10) + " totalCents" + CHR(10) + " itemAmountCents" + CHR(10) + " subtotalCents" + CHR(10) + " commissionAmountCents" + CHR(10) + " postageCents" + CHR(10) + " taxTotalCents" + CHR(10) + " }" + CHR(10) + " }" + CHR(10) + " #This section pulls in amendments based on their remited date" + CHR(10) + " invoiceAmendment {" + CHR(10) + " id" + CHR(10) + " legacyId" + CHR(10) + " remittedAt" + CHR(10) + " totalCents" + CHR(10) + " remittanceCents" + CHR(10) + " lineItemAmountTotalCents" + CHR(10) + " lineItemTaxTotalCents" + CHR(10) + " commissionAmountTotalCents" + CHR(10) + " commissionTaxTotalCents" + CHR(10) + " remittanceAmountTotalCents" + CHR(10) + " remittanceTaxTotalCents" + CHR(10) + " lineItems {" + CHR(10) + " amountCents" + CHR(10) + " taxCents" + CHR(10) + " totalCents" + CHR(10) + " lineItemAmountCents" + CHR(10) + " lineItemTaxCents" + CHR(10) + " commissionAmountCents" + CHR(10) + " commissionTaxCents" + CHR(10) + " remittanceAmountCents" + CHR(10) + " remittanceTaxCents" + CHR(10) + " lineItem {" + CHR(10) + " id" + CHR(10) + " itemAmountCents" + CHR(10) + " taxTotalCents" + CHR(10) + " externalIds {" + CHR(10) + " key" + CHR(10) + " value" + CHR(10) + " }" + CHR(10) + " }" + CHR(10) + " }" + CHR(10) + " #this section pulls in the invoice the invoice ammendment is related to so operators could tie the amendments" + CHR(10) + " invoice {" + CHR(10) + " legacyId" + CHR(10) + " remittedAt" + CHR(10) + " }" + CHR(10) + " }" + CHR(10) + " }" + CHR(10) + " }" + CHR(10) + " }" + CHR(10) + "}" + CHR(10))
loJson.UpdateString("variables",'{' + CHR(10) + ' "pageSize": 50,' + CHR(10) + ' "endCursor": "",' + CHR(10) + ' "createdSince": "2022-01-22T09:30:46-08:00\CHR(10) + '}')
loHttp.SetRequestHeader("Content-Type","application/json")
loHttp.SetRequestHeader("MARKETPLACER-API-KEY","{{api_key}}")
loResp = CreateObject('Chilkat.HttpResponse')
lnSuccess = loHttp.HttpJson("POST","https://bestfriendbazaar.com/graphql",loJson,"application/json",loResp)
IF (lnSuccess = 0) THEN
? loHttp.LastErrorText
RELEASE loHttp
RELEASE loJson
RELEASE loResp
CANCEL
ENDIF
? STR(loResp.StatusCode)
? loResp.BodyStr
RELEASE loHttp
RELEASE loJson
RELEASE loResp
Curl Command
curl -X POST
-u '{{username}}:{{password}}'
-H "MARKETPLACER-API-KEY: {{api_key}}"
-H "Content-Type: application/json"
--data-raw '{"query":"query GetRemittancesWithLineItemBreakdown(\n\t$pageSize: Int\n\t$endCursor: String\n\t$createdSince: ISO8601DateTime\n) {\n\tremittances(\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\tamountCents\n\t\t\t\t#This section pulls in invoices based on their remited date\n\n\t\t\t\tinvoice {\n\t\t\t\t\tid\n\t\t\t\t\tlegacyId\n\t\t\t\t\tremittedAt\n\t\t\t\t\t#total remittance= totalCents-comissionAmountCents-merchantFeeCents-shippingCostCents-taxTotalCents\n\t\t\t\t\ttotalCents\n\t\t\t\t\tcommissionAmountCents\n\t\t\t\t\tmerchantFeeCents\n\t\t\t\t\tshippingCostCents\n\t\t\t\t\ttaxTotalCents\n\t\t\t\t\tlineItems {\n\t\t\t\t\t\tid\n\t\t\t\t\t\t#total remittance= totalCents-comissionAmountCent-postageCents-taxTotalCents\n\t\t\t\t\t\ttotalCents\n\t\t\t\t\t\titemAmountCents\n\t\t\t\t\t\tsubtotalCents\n\t\t\t\t\t\tcommissionAmountCents\n\t\t\t\t\t\tpostageCents\n\t\t\t\t\t\ttaxTotalCents\n\t\t\t\t\t}\n\t\t\t\t}\n\t\t\t\t#This section pulls in amendments based on their remited date\n\t\t\t\tinvoiceAmendment {\n\t\t\t\t\tid\n\t\t\t\t\tlegacyId\n\t\t\t\t\tremittedAt\n\t\t\t\t\ttotalCents\n\t\t\t\t\tremittanceCents\n\t\t\t\t\tlineItemAmountTotalCents\n\t\t\t\t\tlineItemTaxTotalCents\n\t\t\t\t\tcommissionAmountTotalCents\n\t\t\t\t\tcommissionTaxTotalCents\n\t\t\t\t\tremittanceAmountTotalCents\n\t\t\t\t\tremittanceTaxTotalCents\n\t\t\t\t\tlineItems {\n\t\t\t\t\t\tamountCents\n\t\t\t\t\t\ttaxCents\n\t\t\t\t\t\ttotalCents\n\t\t\t\t\t\tlineItemAmountCents\n\t\t\t\t\t\tlineItemTaxCents\n\t\t\t\t\t\tcommissionAmountCents\n\t\t\t\t\t\tcommissionTaxCents\n\t\t\t\t\t\tremittanceAmountCents\n\t\t\t\t\t\tremittanceTaxCents\n\t\t\t\t\t\tlineItem {\n\t\t\t\t\t\t\tid\n\t\t\t\t\t\t\titemAmountCents\n\t\t\t\t\t\t\ttaxTotalCents\n\t\t\t\t\t\t\texternalIds {\n\t\t\t\t\t\t\t\tkey\n\t\t\t\t\t\t\t\tvalue\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\t#this section pulls in the invoice the invoice ammendment is related to so operators could tie the amendments\n\t\t\t\t\tinvoice {\n\t\t\t\t\t\tlegacyId\n\t\t\t\t\t\tremittedAt\n\t\t\t\t\t}\n\t\t\t\t}\n\t\t\t}\n\t\t}\n\t}\n}\n","variables":"{\n\t\"pageSize\": 50,\n\t\"endCursor\": \"\",\n\t\"createdSince\": \"2022-01-22T09:30:46-08:00\"\n}"}'
https://bestfriendbazaar.com/graphql
Postman Collection Item JSON
{
"name": "Remittances with Line Item Breakdown",
"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 GetRemittancesWithLineItemBreakdown(\n\t$pageSize: Int\n\t$endCursor: String\n\t$createdSince: ISO8601DateTime\n) {\n\tremittances(\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\tamountCents\n\t\t\t\t#This section pulls in invoices based on their remited date\n\n\t\t\t\tinvoice {\n\t\t\t\t\tid\n\t\t\t\t\tlegacyId\n\t\t\t\t\tremittedAt\n\t\t\t\t\t#total remittance= totalCents-comissionAmountCents-merchantFeeCents-shippingCostCents-taxTotalCents\n\t\t\t\t\ttotalCents\n\t\t\t\t\tcommissionAmountCents\n\t\t\t\t\tmerchantFeeCents\n\t\t\t\t\tshippingCostCents\n\t\t\t\t\ttaxTotalCents\n\t\t\t\t\tlineItems {\n\t\t\t\t\t\tid\n\t\t\t\t\t\t#total remittance= totalCents-comissionAmountCent-postageCents-taxTotalCents\n\t\t\t\t\t\ttotalCents\n\t\t\t\t\t\titemAmountCents\n\t\t\t\t\t\tsubtotalCents\n\t\t\t\t\t\tcommissionAmountCents\n\t\t\t\t\t\tpostageCents\n\t\t\t\t\t\ttaxTotalCents\n\t\t\t\t\t}\n\t\t\t\t}\n\t\t\t\t#This section pulls in amendments based on their remited date\n\t\t\t\tinvoiceAmendment {\n\t\t\t\t\tid\n\t\t\t\t\tlegacyId\n\t\t\t\t\tremittedAt\n\t\t\t\t\ttotalCents\n\t\t\t\t\tremittanceCents\n\t\t\t\t\tlineItemAmountTotalCents\n\t\t\t\t\tlineItemTaxTotalCents\n\t\t\t\t\tcommissionAmountTotalCents\n\t\t\t\t\tcommissionTaxTotalCents\n\t\t\t\t\tremittanceAmountTotalCents\n\t\t\t\t\tremittanceTaxTotalCents\n\t\t\t\t\tlineItems {\n\t\t\t\t\t\tamountCents\n\t\t\t\t\t\ttaxCents\n\t\t\t\t\t\ttotalCents\n\t\t\t\t\t\tlineItemAmountCents\n\t\t\t\t\t\tlineItemTaxCents\n\t\t\t\t\t\tcommissionAmountCents\n\t\t\t\t\t\tcommissionTaxCents\n\t\t\t\t\t\tremittanceAmountCents\n\t\t\t\t\t\tremittanceTaxCents\n\t\t\t\t\t\tlineItem {\n\t\t\t\t\t\t\tid\n\t\t\t\t\t\t\titemAmountCents\n\t\t\t\t\t\t\ttaxTotalCents\n\t\t\t\t\t\t\texternalIds {\n\t\t\t\t\t\t\t\tkey\n\t\t\t\t\t\t\t\tvalue\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\t#this section pulls in the invoice the invoice ammendment is related to so operators could tie the amendments\n\t\t\t\t\tinvoice {\n\t\t\t\t\t\tlegacyId\n\t\t\t\t\t\tremittedAt\n\t\t\t\t\t}\n\t\t\t\t}\n\t\t\t}\n\t\t}\n\t}\n}\n",
"variables": "{\n\t\"pageSize\": 50,\n\t\"endCursor\": \"\",\n\t\"createdSince\": \"2022-01-22T09:30:46-08:00\"\n}"
}
},
"url": {
"raw": "{{base_url}}",
"host": [
"{{base_url}}"
],
"path": null
},
"description": null
},
"response": [
]
}
