ID CONTAINER_WHOLESALER_RLTD
Method GET
URI
  • https://aucapiapppbspilot.azurewebsites.net/CONTAINER_WHOLESALER_RLTD
Embargo Data No
Requires authentication No
Description This table captures the relationships between wholesalers/suppliers and containers used for extemporaneous benefits

Parameters

Parameter Description Default Required Example
format specifies the output format JSON false ?format=csv
include_header specifies whether a header is included in the results. Note: only works for CSV output formats. false false ?include_header=true
download specifies whether the request should prompt a download response in the user's browser (Chrome compatible) false false ?download=true
CONTAINER_CODE PharmCIS unique identifier code for containers
false ?CONTAINER_CODE=**exampleValue**
ORGANISATION_ID A persistent unique identifier for Organisation that allows the user to infer a wholesaling relationship between the Container and the Organisation
false ?ORGANISATION_ID=**exampleValue**
SCHEDULE_CODE Schedule Code is a unique identifier given to each month's Schedule. By having a Schedule Code in each table, 13 months (schedules) worth of data can be maintained in the Data Mart to assist users in the identification of Delisted Items and change-over-time. In order to see what year/month/effective date a schedule code refers to, look it up in the SCHEDULE_T table
false ?SCHEDULE_CODE=**exampleValue**

 

Example

curl -d https://aucapiapppbspilot.azurewebsites.net/CONTAINER_WHOLESALER_RLTD?format=csv&include_header=true&schedule_code=2710

Sample Response

Get November 2020 Schedule's CONTAINER_WHOLESALER_RLTD data in CSV format
https://aucapiapppbspilot.azurewebsites.net/CONTAINER_WHOLESALER_RLTD?format=csv&include_header=true&schedule_code=2710

Sample output:

 **insert here** 

Created on , last edited on 7/12/2020