Chilkat Online Tools

autoit / Marketplacer SELLER API / allAdverts (Get Products by updated date)

Back to Collection Items

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

$oHttp = ObjCreate("Chilkat.Http")
Local $bSuccess

$oHttp.BasicAuth = True
$oHttp.Login = "{{username}}"
$oHttp.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 AllProductsByUpdatedAtDate(\n\t$updatedSince: ISO8601DateTime\n\t$pageSize: Int\n\t$endCursor: String\n) {\n\tallAdverts(updatedSince: $updatedSince, first: $pageSize, after: $endCursor) {\n\t\tnodes {\n\t\t\t__typename\n\t\t\t... on Advert {\n\t\t\t\tid\n\t\t\t\ttitle\n\t\t\t\tupdatedAt\n\n\t\t\t\timages {\n\t\t\t\t\tnodes {\n\t\t\t\t\t\turl(width: 100, height: 100, fit: clip)\n\t\t\t\t\t}\n\t\t\t\t}\n\t\t\t\tvariants(displayableOnly: false, first: $pageSize) {\n\t\t\t\t\tnodes {\n\t\t\t\t\t\tid\n\t\t\t\t\t}\n\t\t\t\t\tpageInfo {\n\t\t\t\t\t\t...PageInfoPartial\n\t\t\t\t\t}\n\t\t\t\t}\n\t\t\t}\n\t\t\t... on UnpublishedAdvert {\n\t\t\t\tid\n\t\t\t\tupdatedAt\n\t\t\t\tvariants(first: $pageSize) {\n\t\t\t\t\tnodes {\n\t\t\t\t\t\tid\n\t\t\t\t\t}\n\t\t\t\t\tpageInfo {\n\t\t\t\t\t\t...PageInfoPartial\n\t\t\t\t\t}\n\t\t\t\t}\n\t\t\t\tdetails {\n\t\t\t\t\ttitle\n\t\t\t\t}\n\t\t\t}\n\t\t\t... on DeletedAdvert {\n\t\t\t\tid\n\t\t\t\tupdatedAt\n\t\t\t\tvariants(first: 5) {\n\t\t\t\t\tnodes {\n\t\t\t\t\t\tid\n\t\t\t\t\t}\n\t\t\t\t\tpageInfo {\n\t\t\t\t\t\t...PageInfoPartial\n\t\t\t\t\t}\n\t\t\t\t}\n\t\t\t}\n\t\t}\n\t\tpageInfo {\n\t\t\t...PageInfoPartial\n\t\t}\n\t}\n}\n\nfragment PageInfoPartial on PageInfo {\n\thasNextPage\n\tendCursor\n}",
;   "variables": "{\n\t\"pageSize\": 50,\n\t\"endCursor\": null,\n\t\"updatedSince\": \"2023-11-30T09:05:57+11:00\"\n}"
; }

$oJson = ObjCreate("Chilkat.JsonObject")
$oJson.UpdateString("query","query AllProductsByUpdatedAtDate(" & @LF & "	$updatedSince: ISO8601DateTime" & @LF & "	$pageSize: Int" & @LF & "	$endCursor: String" & @LF & ") {" & @LF & "	allAdverts(updatedSince: $updatedSince, first: $pageSize, after: $endCursor) {" & @LF & "		nodes {" & @LF & "			__typename" & @LF & "			... on Advert {" & @LF & "				id" & @LF & "				title" & @LF & "				updatedAt" & @LF & @LF & "				images {" & @LF & "					nodes {" & @LF & "						url(width: 100, height: 100, fit: clip)" & @LF & "					}" & @LF & "				}" & @LF & "				variants(displayableOnly: false, first: $pageSize) {" & @LF & "					nodes {" & @LF & "						id" & @LF & "					}" & @LF & "					pageInfo {" & @LF & "						...PageInfoPartial" & @LF & "					}" & @LF & "				}" & @LF & "			}" & @LF & "			... on UnpublishedAdvert {" & @LF & "				id" & @LF & "				updatedAt" & @LF & "				variants(first: $pageSize) {" & @LF & "					nodes {" & @LF & "						id" & @LF & "					}" & @LF & "					pageInfo {" & @LF & "						...PageInfoPartial" & @LF & "					}" & @LF & "				}" & @LF & "				details {" & @LF & "					title" & @LF & "				}" & @LF & "			}" & @LF & "			... on DeletedAdvert {" & @LF & "				id" & @LF & "				updatedAt" & @LF & "				variants(first: 5) {" & @LF & "					nodes {" & @LF & "						id" & @LF & "					}" & @LF & "					pageInfo {" & @LF & "						...PageInfoPartial" & @LF & "					}" & @LF & "				}" & @LF & "			}" & @LF & "		}" & @LF & "		pageInfo {" & @LF & "			...PageInfoPartial" & @LF & "		}" & @LF & "	}" & @LF & "}" & @LF & @LF & "fragment PageInfoPartial on PageInfo {" & @LF & "	hasNextPage" & @LF & "	endCursor" & @LF & "}")
$oJson.UpdateString("variables","{" & @LF & "	""pageSize"": 50," & @LF & "	""endCursor"": null," & @LF & "	""updatedSince"": ""2023-11-30T09:05:57+11:00\@LF & "}")

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

$oResp = ObjCreate("Chilkat.HttpResponse")
$bSuccess = $oHttp.HttpJson("POST","https://bestfriendbazaar.com/graphql",$oJson,"application/json",$oResp)
If ($bSuccess = False) Then
    ConsoleWrite($oHttp.LastErrorText & @CRLF)
    Exit
EndIf

ConsoleWrite($oResp.StatusCode & @CRLF)
ConsoleWrite($oResp.BodyStr & @CRLF)

Curl Command

curl -X POST
	-u '{{username}}:{{password}}'
	-H "MARKETPLACER-API-KEY: {{api_key}}"
	-H "Content-Type: application/json"
	--data-raw '{"query":"query AllProductsByUpdatedAtDate(\n\t$updatedSince: ISO8601DateTime\n\t$pageSize: Int\n\t$endCursor: String\n) {\n\tallAdverts(updatedSince: $updatedSince, first: $pageSize, after: $endCursor) {\n\t\tnodes {\n\t\t\t__typename\n\t\t\t... on Advert {\n\t\t\t\tid\n\t\t\t\ttitle\n\t\t\t\tupdatedAt\n\n\t\t\t\timages {\n\t\t\t\t\tnodes {\n\t\t\t\t\t\turl(width: 100, height: 100, fit: clip)\n\t\t\t\t\t}\n\t\t\t\t}\n\t\t\t\tvariants(displayableOnly: false, first: $pageSize) {\n\t\t\t\t\tnodes {\n\t\t\t\t\t\tid\n\t\t\t\t\t}\n\t\t\t\t\tpageInfo {\n\t\t\t\t\t\t...PageInfoPartial\n\t\t\t\t\t}\n\t\t\t\t}\n\t\t\t}\n\t\t\t... on UnpublishedAdvert {\n\t\t\t\tid\n\t\t\t\tupdatedAt\n\t\t\t\tvariants(first: $pageSize) {\n\t\t\t\t\tnodes {\n\t\t\t\t\t\tid\n\t\t\t\t\t}\n\t\t\t\t\tpageInfo {\n\t\t\t\t\t\t...PageInfoPartial\n\t\t\t\t\t}\n\t\t\t\t}\n\t\t\t\tdetails {\n\t\t\t\t\ttitle\n\t\t\t\t}\n\t\t\t}\n\t\t\t... on DeletedAdvert {\n\t\t\t\tid\n\t\t\t\tupdatedAt\n\t\t\t\tvariants(first: 5) {\n\t\t\t\t\tnodes {\n\t\t\t\t\t\tid\n\t\t\t\t\t}\n\t\t\t\t\tpageInfo {\n\t\t\t\t\t\t...PageInfoPartial\n\t\t\t\t\t}\n\t\t\t\t}\n\t\t\t}\n\t\t}\n\t\tpageInfo {\n\t\t\t...PageInfoPartial\n\t\t}\n\t}\n}\n\nfragment PageInfoPartial on PageInfo {\n\thasNextPage\n\tendCursor\n}","variables":"{\n\t\"pageSize\": 50,\n\t\"endCursor\": null,\n\t\"updatedSince\": \"2023-11-30T09:05:57+11:00\"\n}"}'
https://bestfriendbazaar.com/graphql

Postman Collection Item JSON

{
  "name": "allAdverts (Get Products by updated date)",
  "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 AllProductsByUpdatedAtDate(\n\t$updatedSince: ISO8601DateTime\n\t$pageSize: Int\n\t$endCursor: String\n) {\n\tallAdverts(updatedSince: $updatedSince, first: $pageSize, after: $endCursor) {\n\t\tnodes {\n\t\t\t__typename\n\t\t\t... on Advert {\n\t\t\t\tid\n\t\t\t\ttitle\n\t\t\t\tupdatedAt\n\n\t\t\t\timages {\n\t\t\t\t\tnodes {\n\t\t\t\t\t\turl(width: 100, height: 100, fit: clip)\n\t\t\t\t\t}\n\t\t\t\t}\n\t\t\t\tvariants(displayableOnly: false, first: $pageSize) {\n\t\t\t\t\tnodes {\n\t\t\t\t\t\tid\n\t\t\t\t\t}\n\t\t\t\t\tpageInfo {\n\t\t\t\t\t\t...PageInfoPartial\n\t\t\t\t\t}\n\t\t\t\t}\n\t\t\t}\n\t\t\t... on UnpublishedAdvert {\n\t\t\t\tid\n\t\t\t\tupdatedAt\n\t\t\t\tvariants(first: $pageSize) {\n\t\t\t\t\tnodes {\n\t\t\t\t\t\tid\n\t\t\t\t\t}\n\t\t\t\t\tpageInfo {\n\t\t\t\t\t\t...PageInfoPartial\n\t\t\t\t\t}\n\t\t\t\t}\n\t\t\t\tdetails {\n\t\t\t\t\ttitle\n\t\t\t\t}\n\t\t\t}\n\t\t\t... on DeletedAdvert {\n\t\t\t\tid\n\t\t\t\tupdatedAt\n\t\t\t\tvariants(first: 5) {\n\t\t\t\t\tnodes {\n\t\t\t\t\t\tid\n\t\t\t\t\t}\n\t\t\t\t\tpageInfo {\n\t\t\t\t\t\t...PageInfoPartial\n\t\t\t\t\t}\n\t\t\t\t}\n\t\t\t}\n\t\t}\n\t\tpageInfo {\n\t\t\t...PageInfoPartial\n\t\t}\n\t}\n}\n\nfragment PageInfoPartial on PageInfo {\n\thasNextPage\n\tendCursor\n}",
        "variables": "{\n\t\"pageSize\": 50,\n\t\"endCursor\": null,\n\t\"updatedSince\": \"2023-11-30T09:05:57+11:00\"\n}"
      }
    },
    "url": {
      "raw": "{{base_url}}",
      "host": [
        "{{base_url}}"
      ],
      "path": null
    },
    "description": null
  },
  "response": [
  ]
}