Data fields returned through a GET request are encoded in the response body (in JSON format) and take the form of a preformatted Variant() array data type with two dimensions in VBA. OpenApiGetAutoResize() will automatically adjust the output array on a worksheet depending on the amount of columns and rows returned by the API.
The below example showcases how data is returned in worksheet cells through AutoResize, and what the corresponding request in VBA looks like. Three fields are pulled from the /netpositions/ endpoint: the position's ID, exposure in base currency and the description of the position:
Performing a similar request in VBA:
Which prints the following ouput to the debug console: