Find Transaction [Retail API]

[haqureshi]

Hi, I am having difficulty to understand how can i call Find Transaction via Retail API?
Do you have documentation available in this regard, which help us to understand the implementation process?

This is the reference of what we need to call from API to automate the process
https://mis.ercot.com/secure/applications
[Find Transactions]

If you can share sample request will be very helpful

[sjinright-ercot]

Hi, I'm working on publishing documentation to the developer portal for this service. In the meantime, here is are two different example requests and responses for Find Transaction.

Find Transaction:TrxnRequest Request:

POST /retailAPI/ HTTP/1.1
Host: misapi.ercot.com
SOAPAction: /BusinessService/WS/Public/RetailAPIExternal.serviceagent/input/GetTrxn
Content-Length: 451

<soap:Envelope xmlns:soap="http://www.w3.org/2003/05/soap-envelope" xmlns:ns="http://www.ercot.com/schema/retail-wholesale/2006-05">
   <soap:Header/>
   <soap:Body>
      <ns:TrxnRequest>
         <Request>        
            <globalId>000000000000ESIID123456789ABCDEFGHIJBGN06ORIGID123456789ABCDE</globalId>
            <!--Optional:-->
            <tranID></tranID>
         </Request>
      </ns:TrxnRequest>
   </soap:Body>
</soap:Envelope>

Find Transaction:TrxnRequest Response:

<?xml version = "1.0" encoding = "UTF-8"?>
<soap:Envelope xmlns:soap="http://www.w3.org/2003/05/soap-envelope" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
    <soap:Body>
        <ns0:TrxnResponse xmlns:ns0="http://www.ercot.com/schema/retail-wholesale/2006-05" xmlns:SOAP-ENV="http://www.w3.org/2003/05/soap-envelope">
            <Count>3</Count>
            <TransactionResponse>
                <globalId>000000000000ESIID123456789ABCDEFGHIJBGN06ORIGID123456789ABCDE</globalId>
                <id>BGN06ORIGID123456789ABCDE</id>
                <ESIID>ESIID123456789ABCDEFGHIJ</ESIID>
                <originalXaNumber>BGN06ORIGID123456789ABCDE</originalXaNumber>
                <type>814_16</type>
                <fromMPduns>111111111</fromMPduns>
                <toMPduns>183529049</toMPduns>
                <submittedDateStr>20241227134933</submittedDateStr>
                <status>Accept</status>
                <xmlPayload>&lt;BusinessProcess/&gt;</xmlPayload>
                <retryStatus/>
                <ercotId>20250102</ercotId>
                <duplicate>false</duplicate>
            </TransactionResponse>
            <TransactionResponse>
                <globalId>000000000000ESIID123456789ABCDEFGHIJBGN06ORIGID123456789ABCDE</globalId>
                <id>819272110202412271349346666666</id>
                <ESIID>ESIID123456789ABCDEFGHIJ</ESIID>
                <originalXaNumber>BGN06ORIGID123456789ABCDE</originalXaNumber>
                <type>814_03</type>
                <fromMPduns>183529049</fromMPduns>
                <toMPduns>666666666</toMPduns>
                <submittedDateStr>20241227134934</submittedDateStr>
                <status>Accept</status>
                <xmlPayload>&lt;BusinessProcess/&gt;</xmlPayload>
                <retryStatus/>
                <ercotId>20250102</ercotId>
                <duplicate>false</duplicate>
            </TransactionResponse>
            <TransactionResponse>
                <globalId>000000000000ESIID123456789ABCDEFGHIJBGN06ORIGID123456789ABCDE</globalId>
                <id>SBMI2025010200085411G3604W</id>
                <ESIID>ESIID123456789ABCDEFGHIJ</ESIID>
                <originalXaNumber>BGN06ORIGID123456789ABCDE</originalXaNumber>
                <type>814_08</type>
                <fromMPduns>183529049</fromMPduns>
                <toMPduns>666666666</toMPduns>
                <submittedDateStr>20250102001439</submittedDateStr>
                <status>Accept</status>
                <xmlPayload>&lt;BusinessProcess/&gt;</xmlPayload>
                <retryStatus/>
                <ercotId/>
                <duplicate>false</duplicate>
            </TransactionResponse>
        </ns0:TrxnResponse>
    </soap:Body>
</soap:Envelope>

Find Transaction:OrigXARequest Request:

POST /retailAPI/ HTTP/1.1
Host: misapi.ercot.com
SOAPAction: /BusinessService/WS/Public/RetailAPIExternal.serviceagent/input/GetOrigXA
Content-Length: 424

<soap:Envelope xmlns:soap="http://www.w3.org/2003/05/soap-envelope" xmlns:ns="http://www.ercot.com/schema/retail-wholesale/2006-05">
   <soap:Header/>
   <soap:Body>
      <ns:OrigXARequest>
         <Request>
            <ESIID>ESIID123456789ABCDEFGHIJ</ESIID>
            <StartDate>20241226</StartDate>
            <EndDate>20250106</EndDate>
         </Request>
      </ns:OrigXARequest>
   </soap:Body>
</soap:Envelope>

Find Transaction:OrigXARequest Response:

<?xml version = "1.0" encoding = "UTF-8"?>
<soap:Envelope xmlns:soap="http://www.w3.org/2003/05/soap-envelope" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
    <soap:Body>
        <ns0:OrigXAResponse xmlns:ns0="http://www.ercot.com/schema/retail-wholesale/2006-05" xmlns:SOAP-ENV="http://www.w3.org/2003/05/soap-envelope">
            <Count>2</Count>
            <TransactionResponse>
                <ESIID>ESIID123456789ABCDEFGHIJ</ESIID>
                <originalXaNumber>BGN06ORIGID123456789ABCDE</originalXaNumber>
                <tranID>BGN06ORIGID123456789ABCDE</tranID>
                <globalId>000000000000ESIID123456789ABCDEFGHIJBGN06ORIGID123456789ABCDE</globalId>
                <type>814_16</type>
                <timeStamp>2024-12-27T13:49:33.011-06:00</timeStamp>
                <toMPDuns>183529049</toMPDuns>
                <fromMPDuns>111111111</fromMPDuns>
            </TransactionResponse>
            <TransactionResponse>
                <ESIID>ESIID123456789ABCDEFGHIJ</ESIID>
                <originalXaNumber>OTIDA2020250102LT50FH2018</originalXaNumber>
                <tranID>OTIDA2020250102LT50FH2018</tranID>
                <globalId>000000000000ESIID123456789ABCDEFGHIJOTIDA2020250102LT50FH2018</globalId>
                <type>814_20</type>
                <timeStamp>2024-12-27T10:51:32.113-06:00</timeStamp>
                <toMPDuns>183529049</toMPDuns>
                <fromMPDuns>666666666</fromMPDuns>
            </TransactionResponse>
        </ns0:OrigXAResponse>
    </soap:Body>
</soap:Envelope>

[haqureshi]

Thanks you so much. I am able to call API and getting valid response from the API.

What is 814_16 ?
I need to know the number of MVIs for an ESI ID, see below as reference

[msury21]

Hi, has anything changed with the address of the api? When I try, all I get is location.href = "/error/404-not-found" . I am following the OrigXARequest formatting.

[haqureshi]

Thanks you so much. I am able to call API and getting valid response from the API.

What is 814_16 ?
I need to know the number of MVIs for an ESI ID, see below as reference

[madkins1868]

An 814_16 is a switch request in comparison to an 814_01 which is a Move In. This is for a customer who is switching from one retailer to another.

[sjinright-ercot]

Hi, just to clarify, an 814_16 is a Move-In and an 814_01 is a Switch. You can find the latest TXSET EDI guides at this link that describe the transactions in detail.
https://www.ercot.com/mktrules/guides/txset/version
Thanks,
Susan

[madkins1868]

I always get those backwards. Thanks for the clarification...