DTXQL Rest API Service Request Failing For Gift Card/Certificate Transactions
(Doc ID 2707559.1)
Last updated on MARCH 07, 2023
Applies to:Oracle Retail Xstore Office Cloud Service - Version NA and later
Information in this document applies to any platform.
DTXQL Rest API service request failing for Gift Card/Certificate transactions.
Developing an interface for fetching transactions from Xstore Office Cloud (XOC) using DTXQL Rest API service and persisting them in On-Prem DB.
QA testing found that DTXQL services quite often gives 400 BAD REQUEST error even though all the transactions are replicated properly to XOC.
Below are the observations:
- The service will fire DTXQL query every hour and will fetch all transactions from XOC done during the hour.
- Issue is DTXQL is failing for certain individual transactions and then it fails to retrieve any transactions for that time period.
- On analyzing transaction by transaction it can be seen that certain transactions like Gift Certificate Issued/Redeem, Returns with Store Credit Issue/Redeem get a Bad request error and due to which the entire set of transactions is not retrieved for that time period.
- It has been confirmed that the transactions were replicated successfully to XOC and can be retrieved in EJournal.
When this occurs, a "400 bad request" error is shown which fails the entire batch of transactions, not just the single transaction.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document