Web submission csv payload
Do not include quotation marks in your payload.
Payload parameters
Field name |
Description |
Status |
Data type |
Format |
Example |
---|---|---|---|---|---|
GasFutureId |
The EFP ID for the Final EFP Trade |
Optional for a Preliminary EFP Trade Submission Required for Final EFP Trade |
20 alphanumeric characters |
ASX-AEMO-nnnn-NNNNNN |
ASX-AEMO-1234-AA5678 |
StartDate |
Start of Delivery Period |
Required |
Date |
YYYY/MM/DD Include leading zeros in dates |
2021/04/01 |
EndDate |
End of Delivery Period |
Required |
Date |
YYYY/MM/DD Include leading zeros in dates |
2021/04/30 |
Buy or sell |
Required |
Varchar |
BUY SELL Must be uppercase |
BUY |
|
Trade price |
Required |
Number |
2 decimal places Correct: 100.20, 100 Incorrect: 100., 100.00001 No $ sign Currency is in Australian dollars |
5.23 |
|
EFP Trade quantities measured in GJ for each Gas Day in the Delivery Period |
Required |
Number |
Gigajoules (GJ) Must be a whole number |
234 |
|
product_group_code |
Participants can submit but data is not saved by AEMO |
Optional |
n/a |
n/a |
GAS-WAL |
product_type_code |
Gas – NG Months |
||||
delivery_point |
WAL HP Trade Point |
||||
lots |
10 |
||||
counterparty_clearer |
JPM |
||||
beneficiary_detail |
CPXYZ Ltd |
||||
series |
GZU22 |
Payload naming rules
Except for the extension which must be csv Comma Separated Values. A file format for data using commas as delimiters., there is no format for the payload name for either interface. Spaces are accepted. For example:
-
ParticipantID-yyyymmdd.csv
Payload structure
-
The field name format is important, see Payload parameters.
-
Extra or optional columns are ignored and not saved in AEMO Australian Energy Market Operator’s systems.
-
The column order doesn’t matter.
Csv payload example
Do not include quotation marks in your payload.
Example with optional fields.
Text payload example
Example with optional fields.