MENU
    Transaction Data Extract APIs
    • 1 Minute to read
    • Dark
    • PDF

    Transaction Data Extract APIs

    • Dark
    • PDF

    Article summary

    TransactionDataExtract_SubmitRequest API

    Use this SOAP API to get the transaction details from the Planful database. You can add filters to the API request and get filtered transaction data. The API call creates a job that extracts the data into an encrypted text file at a secure FTP location. This location is finalized when the Planful support team configures the APIs for your environment.

    Sample API Request

    <soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:ns="http://www.HostAnalytics.com/API/SOAP/StateFree/Common/2009/03/19">   <soapenv:Header/>   <soapenv:Body>      <ns:TransactionDataExtract_SubmitRequest>         <ns:LoginName>ryennam@planful.com</ns:LoginName>         <ns:Password>TeStPasswd@20</ns:Password>         <ns:TenantCode>TechOpsTest</ns:TenantCode>         <ns:Request>            <ns:FilterCriteria>               <ns:TransactionDateFrom>2020-03-25</ns:TransactionDateFrom>               <ns:TransactionDateTo>2020-04-24</ns:TransactionDateTo>               <ns:FieldFilters>                  <ns:Field>                     <ns:Name>Entity</ns:Name>                     <ns:Operator>Equals</ns:Operator>                     <ns:Values>                        <ns:string>01</ns:string>                     </ns:Values>                  </ns:Field>               </ns:FieldFilters>            </ns:FilterCriteria>         </ns:Request>      </ns:TransactionDataExtract_SubmitRequest>   </soapenv:Body></soapenv:Envelope>
    JSON


    Note
    The LoginName, Password, and TenantCode parameters are mandatory.
    Note
    You can use the Equals, GreaterThan, GreaterThanEqualTo, LessThan, LessThanEqualTo Operators in the API call for the Operator parameter.


    As of today, this API supports the following filter criteria:

    • From and To transaction dates, 
    • Segment codes 
    • Attributes 

    Sample API Response:

    <soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">   <soap:Body>      <TransactionDataExtract_SubmitRequestResponse xmlns="http://www.HostAnalytics.com/API/SOAP/StateFree/Common/2009/03/19">         <TransactionDataExtract_SubmitRequestResult>            <ReferenceId>a9e0d7fd-76d9-4657-a105-cb1b237312c3</ReferenceId>            <Status>Submitted</Status>            <Errors>               <Error>                  <Code> </Code>                  <Message> </Message>               </Error>            </Errors>         </TransactionDataExtract_SubmitRequestResult>      </TransactionDataExtract_SubmitRequestResponse>   </soap:Body></soap:Envelope>
    JSON

    TransactionDataExtract_RetrieveStatusResult API

    You can use this SOAP API to get the actual status of the data extraction that was initiated using the TransactionDataExtract_SubmitRequest API. When an extraction request is submitted, a reference ID is generated and sent in the API response. You can use that reference ID to get the current status of that transaction data extract request.

    Sample API Request:

    <soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:ns="http://www.HostAnalytics.com/API/SOAP/StateFree/Common/2009/03/19">   <soapenv:Header/>   <soapenv:Body>      <ns:TransactionDataExtract_RetrieveStatus>          <ns:LoginName>ryennam@planful.com</ns:LoginName>         <ns:Password>TeStPasswd@20</ns:Password>         <ns:TenantCode>TechOpsTest</ns:TenantCode>         <ns:Request>            <ns:ReferenceId>a9e0d7fd-76d9-4657-a105-cb1b237312c3</ns:ReferenceId>         </ns:Request>      </ns:TransactionDataExtract_RetrieveStatus>   </soapenv:Body></soapenv:Envelope>
    JSON

    Sample API Response:

    <soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">   <soap:Body>      <TransactionDataExtract_RetrieveStatusResponse xmlns="http://www.HostAnalytics.com/API/SOAP/StateFree/Common/2009/03/19">         <TransactionDataExtract_RetrieveStatusResult>            <ReferenceId>a9e0d7fd-76d9-4657-a105-cb1b237312c3</ReferenceId>            <Status>Completed</Status>            <RowsProcessed>100</RowsProcessed>            <ErrorReason/>            <SubmissionDate>2020-10-20T02:36:08.38</SubmissionDate>         </TransactionDataExtract_RetrieveStatusResult>      </TransactionDataExtract_RetrieveStatusResponse>   </soap:Body></soap:Envelope>
    JSON


    Note
    To use the above-mentioned transaction data extraction APIs, you have to reach out to the Planful support team. The support team will configure these APIs for your environment and then you can start using these APIs.



    Was this article helpful?