Chilkat Online Tools

VB.NET / easybill REST API / Fetch a list of stock entries for positions

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

Dim queryParams As New Chilkat.JsonObject
queryParams.UpdateString("limit","<integer>")
queryParams.UpdateString("page","<integer>")
queryParams.UpdateString("position_id","<string>")
queryParams.UpdateString("document_id","<string>")

http.SetRequestHeader("Authorization","{{apiKey}}")
http.SetRequestHeader("Accept","application/json")


Dim resp As Chilkat.HttpResponse = http.QuickRequestParams("GET","https://api.easybill.de/rest/v1/stocks",queryParams)
If (http.LastMethodSuccess = False) Then
    Debug.WriteLine(http.LastErrorText)
    Exit Sub
End If


Dim sbResponseBody As New Chilkat.StringBuilder
resp.GetBodySb(sbResponseBody)

Dim jResp As New Chilkat.JsonObject
jResp.LoadSb(sbResponseBody)
jResp.EmitCompact = False

Debug.WriteLine("Response Body:")
Debug.WriteLine(jResp.Emit())

Dim respStatusCode As Integer = resp.StatusCode
Debug.WriteLine("Response Status Code = " & respStatusCode)
If (respStatusCode >= 400) Then
    Debug.WriteLine("Response Header:")
    Debug.WriteLine(resp.Header)
    Debug.WriteLine("Failed.")

    Exit Sub
End If



' Sample JSON response:
' (Sample code for parsing the JSON response is shown below)

' {
'   "page": "<integer>",
'   "pages": "<integer>",
'   "limit": "<integer>",
'   "total": "<integer>",
'   "items": [
'     {
'       "stock_count": "<long>",
'       "position_id": "<long>",
'       "id": "<long>",
'       "note": "<string>",
'       "document_id": "<long>",
'       "document_position_id": "<long>",
'       "stored_at": "<string>",
'       "created_at": "<string>",
'       "updated_at": "<string>"
'     },
'     {
'       "stock_count": "<long>",
'       "position_id": "<long>",
'       "id": "<long>",
'       "note": "<string>",
'       "document_id": "<long>",
'       "document_position_id": "<long>",
'       "stored_at": "<string>",
'       "created_at": "<string>",
'       "updated_at": "<string>"
'     }
'   ]
' }

' Sample code for parsing the JSON response...
' Use this online tool to generate parsing code from sample JSON: Generate JSON Parsing Code



Dim stock_count As String
Dim position_id As String
Dim id As String
Dim note As String
Dim document_id As String
Dim document_position_id As String
Dim stored_at As String
Dim created_at As String
Dim updated_at As String

Dim page As String = jResp.StringOf("page")
Dim pages As String = jResp.StringOf("pages")
Dim limit As String = jResp.StringOf("limit")
Dim total As String = jResp.StringOf("total")
Dim i As Integer = 0
Dim count_i As Integer = jResp.SizeOfArray("items")
While i < count_i
    jResp.I = i
    stock_count = jResp.StringOf("items[i].stock_count")
    position_id = jResp.StringOf("items[i].position_id")
    id = jResp.StringOf("items[i].id")
    note = jResp.StringOf("items[i].note")
    document_id = jResp.StringOf("items[i].document_id")
    document_position_id = jResp.StringOf("items[i].document_position_id")
    stored_at = jResp.StringOf("items[i].stored_at")
    created_at = jResp.StringOf("items[i].created_at")
    updated_at = jResp.StringOf("items[i].updated_at")
    i = i + 1
End While

Curl Command

curl -G -d "limit=%3Cinteger%3E"
	-d "page=%3Cinteger%3E"
	-d "position_id=%3Cstring%3E"
	-d "document_id=%3Cstring%3E"
	-H "Authorization: {{apiKey}}"
	-H "Accept: application/json"
https://api.easybill.de/rest/v1/stocks

Postman Collection Item JSON

{
  "name": "Fetch a list of stock entries for positions",
  "request": {
    "method": "GET",
    "header": [
      {
        "key": "Accept",
        "value": "application/json"
      }
    ],
    "url": {
      "raw": "{{baseUrl}}/stocks?limit=<integer>&page=<integer>&position_id=<string>&document_id=<string>",
      "host": [
        "{{baseUrl}}"
      ],
      "path": [
        "stocks"
      ],
      "query": [
        {
          "key": "limit",
          "value": "<integer>",
          "description": "Limited the result. Default is 100. Maximum can be 1000."
        },
        {
          "key": "page",
          "value": "<integer>",
          "description": "Set current Page. Default is 1."
        },
        {
          "key": "position_id",
          "value": "<string>",
          "description": "Filter stock entries by position id."
        },
        {
          "key": "document_id",
          "value": "<string>",
          "description": "Filter stock entries by document id."
        }
      ]
    }
  },
  "response": [
    {
      "name": "Successful operation",
      "originalRequest": {
        "method": "GET",
        "header": [
          {
            "key": "Accept",
            "value": "application/json"
          },
          {
            "description": "Added as a part of security scheme: apikey",
            "key": "Authorization",
            "value": "<API Key>"
          }
        ],
        "url": {
          "raw": "{{baseUrl}}/stocks?limit=<integer>&page=<integer>&position_id=<string>&document_id=<string>",
          "host": [
            "{{baseUrl}}"
          ],
          "path": [
            "stocks"
          ],
          "query": [
            {
              "key": "limit",
              "value": "<integer>",
              "description": "Limited the result. Default is 100. Maximum can be 1000."
            },
            {
              "key": "page",
              "value": "<integer>",
              "description": "Set current Page. Default is 1."
            },
            {
              "key": "position_id",
              "value": "<string>",
              "description": "Filter stock entries by position id."
            },
            {
              "key": "document_id",
              "value": "<string>",
              "description": "Filter stock entries by document id."
            }
          ]
        }
      },
      "status": "OK",
      "code": 200,
      "_postman_previewlanguage": "json",
      "header": [
        {
          "key": "Content-Type",
          "value": "application/json"
        }
      ],
      "cookie": [
      ],
      "body": "{\n  \"page\": \"<integer>\",\n  \"pages\": \"<integer>\",\n  \"limit\": \"<integer>\",\n  \"total\": \"<integer>\",\n  \"items\": [\n    {\n      \"stock_count\": \"<long>\",\n      \"position_id\": \"<long>\",\n      \"id\": \"<long>\",\n      \"note\": \"<string>\",\n      \"document_id\": \"<long>\",\n      \"document_position_id\": \"<long>\",\n      \"stored_at\": \"<string>\",\n      \"created_at\": \"<string>\",\n      \"updated_at\": \"<string>\"\n    },\n    {\n      \"stock_count\": \"<long>\",\n      \"position_id\": \"<long>\",\n      \"id\": \"<long>\",\n      \"note\": \"<string>\",\n      \"document_id\": \"<long>\",\n      \"document_position_id\": \"<long>\",\n      \"stored_at\": \"<string>\",\n      \"created_at\": \"<string>\",\n      \"updated_at\": \"<string>\"\n    }\n  ]\n}"
    },
    {
      "name": "Too Many Requests",
      "originalRequest": {
        "method": "GET",
        "header": [
          {
            "description": "Added as a part of security scheme: apikey",
            "key": "Authorization",
            "value": "<API Key>"
          }
        ],
        "url": {
          "raw": "{{baseUrl}}/stocks?limit=<integer>&page=<integer>&position_id=<string>&document_id=<string>",
          "host": [
            "{{baseUrl}}"
          ],
          "path": [
            "stocks"
          ],
          "query": [
            {
              "key": "limit",
              "value": "<integer>",
              "description": "Limited the result. Default is 100. Maximum can be 1000."
            },
            {
              "key": "page",
              "value": "<integer>",
              "description": "Set current Page. Default is 1."
            },
            {
              "key": "position_id",
              "value": "<string>",
              "description": "Filter stock entries by position id."
            },
            {
              "key": "document_id",
              "value": "<string>",
              "description": "Filter stock entries by document id."
            }
          ]
        }
      },
      "status": "Too Many Requests",
      "code": 429,
      "_postman_previewlanguage": "text",
      "header": [
      ],
      "cookie": [
      ],
      "body": ""
    }
  ]
}