Continental Power Exchange: Day Offering Automated Query Test

CPEX conducted a series of tests to evaluate the support for automated querying. Four queries comprised the test, based on the simple dayoffering template using the DATA OUTPUT_FORMAT (see below.) The tests were:

1 - query for Capacity Types
2 - query for Path Names
3 - query for Price
4 - query for Available Capacity

"PASS" or "FAIL" scores were determined by the completeness of the results. If return fields were filled and the data correlated with that shown on the provider's HTML screen, the test score was assigned a "PASS". If return fields were missing or filled with inappropriate data, the test score was "Fail." If one or more of the above-noted tests failed, the overall test was assigned a "Fail" and posted to http://www.tsin.com/oasistest/testresults.html.

Test 1

Query for Test 1: List of paths

http:
//mapp.oasis.mapp.org:488/OASIS/DPC/data/list?OUTPUT_FORMAT=DATA&LIST_NAME=PATH

Reply for Test 1: (PASS)

REQUEST_STATUS=200
ERROR_MESSAGE=""
TIME_STAMP=19970416082251CD
VERSION=1.0
TEMPLATE=list
OUTPUT_FORMAT=DATA
PRIMARY_PROVIDER=Dairyland Power Coop.
PRIMARY_PROVIDER_DUNS=958994501
DATA_ROWS=8
COLUMN_HEADERS="TIME_OF_LAST_UPDATE","LIST_NAME","LIST_ITEM","LIST_ITEM_DESCRIPT ION"
"19970108131511CD","PATH","A/DPC/DPC-IPW//",""
"19970108135116CD","PATH","A/DPC/IPW-DPC//",""
"19970108135248CD","PATH","A/DPC/DPC-NSP//",""
"19970108141502CD","PATH","A/DPC/NSP-DPC//",""
"19970108141922CD","PATH","A/DPC/DPC-WPL//",""
"19970108142006CD","PATH","A/DPC/DPC-SMMPA//",""
"19970108142032CD","PATH","A/DPC/SMMPA-DPC//",""
"19970108142315CD","PATH","A/DPC/WPL-DPC//",""

Test 2

Query for Test 2: List of Capacity types

http:
//mapp.oasis.mapp.org:488/OASIS/DPC/data/list?OUTPUT_FORMAT=DATA&LIST_NAME=CAPACITY_TYPE

Reply for Test 2: (PASS)

REQUEST_STATUS=200
ERROR_MESSAGE=""
TIME_STAMP=19970416082711CD
VERSION=1.0
TEMPLATE=list
OUTPUT_FORMAT=DATA
PRIMARY_PROVIDER=Dairyland Power Coop.
PRIMARY_PROVIDER_DUNS=958994501
DATA_ROWS=14
COLUMN_HEADERS="TIME_OF_LAST_UPDATE","LIST_NAME","LIST_ITEM","LIST_ITEM_DESCRIPTION"
"19970108101051CD","CAPACITY_TYPE","Daily Firm",""
"19970108100941CD","CAPACITY_TYPE","Daily Firm ATC",""
"19970108100912CD","CAPACITY_TYPE","Daily Non-Firm",""
"19970108100842CD","CAPACITY_TYPE","Daily TTC",""
"19970110113356CD","CAPACITY_TYPE","Hourly Non-Firm",""
"19970108100736CD","CAPACITY_TYPE","Hourly TTC",""
"19970108101251CD","CAPACITY_TYPE","Monthly Firm",""
"19970108174027CD","CAPACITY_TYPE","Monthly Firm ATC",""
"19970108101534CD","CAPACITY_TYPE","Monthly Non-Firm",""
"19970108102255CD","CAPACITY_TYPE","Monthly TTC",""
"19970108161855CD","CAPACITY_TYPE","Weekly Firm",""
"19970108172028CD","CAPACITY_TYPE","Weekly Firm ATC",""
"19970108171805CD","CAPACITY_TYPE","Weekly Non-Firm",""
"19970108105537CD","CAPACITY_TYPE","Weekly TTC",""

Tests 3 and 4

Query for Test 3 and 4: Price and ATC

http:
//mapp.oasis.mapp.org:488/OASIS/DPC/dayoffering?VERSION=1.1&
TEMPLATE=dayoffering&
OUTPUT_FORMAT=DATA&
PRIMARY_PROVIDER=Dairyland+Power+Coop.&
PRIMARY_PROVIDER_DUNS=958994501&
CAPACITY_TYPE=Daily+Non-Firm&
BEGTIME=19970402000000CS&
ENDTIME=19970403000000CS&
PATH_NAME=A%2FDPC%2FNSP%2DDPC%2F%2F

Reply for Test 3 (FAIL) and 4 (FAIL):

REQUEST_STATUS=200
ERROR_MESSAGE=""
TIME_STAMP=19970416092123CD
VERSION=1.0
TEMPLATE=dayoffering
OUTPUT_FORMAT=DATA
PRIMARY_PROVIDER=Dairyland Power Coop.
PRIMARY_PROVIDER_DUNS=958994501
DATA_ROWS=0
COLUMN_HEADERS="TIME_OF_LAST_UPDATE","SELLER","SELLER_DUNS","PATH_NAME","POINT_OF_
RECEIPT","POINT_OF_DELIVERY","INTERFACE_TYPE","","CAPACITY","CAPACITY_TYPE","SALE_R
EF","PRICE","PRICE_UNITS","SELLER_NAME","SELLER_PHONE","SELLER_FAX","SELLER_E-
MAIL","SE

Verifying Results

To test CPEX's query on your system, edit the Query below by changing the variables as appropriate. Pay attention to the URL address, PRIMARY_PROVIDER, PRIMARY_PROVIDER_DUNS,and CAPACITY_TYPE entering the correct and exact information. Also,build the PATH_NAME using the text string "%2F" as the hexidecimal equivalent of "/", and "%2D" equals "-". Remove the "carriage returns" and then copy the entire query into your Windows clipboard (use copy or Control C). Then paste the query (use paste or Control V) into the URL space of your browser and press the key. Note: This process may not work if you use Microsoft Net-it seemed unable to accept a URL string longer than 128 characters.

http:
//oasis.maininc.org:488/OASIS/TVA/data/dayoffering?VERSION=1.1&
TEMPLATE=dayoffering&
OUTPUT_FORMAT=DATA&
PRIMARY_PROVIDER=Tennessee+Valley+Auth&
PRIMARY_PROVIDER_DUNS=960520211&
CAPACITY_TYPE=NFDY&
BEGTIME=19970402000000CS&
ENDTIME=19970403000000CS&
PATH_NAME=s%2Ftva%2Fekpc%2Dees%2F%2F

The results will be in text file format that you will have to save on your computer. Once saved, open it with a text editor (Notepad works fine) and view it for completeness.