Help, what am I missing?
I’m using Apex 20.2 on Autonomous and I’m trying to setup what I thought was a simple REST Data Source to call the eBay XML API. I have all the credentials and the call itself correct as I’m getting a response back, but I’m struggling to parse it.
I have the Data Profile setup as follows:
Response Format: XML
Row Selector: /GeteBayOfficialTimeResponse
Contains Single Row: No (I know this is a single row, but I understand from the help next to it that it can be taken into a collection too)
I’ve tried to use ‘Rediscover Data Profile’ without anything in the Sample Response field and and that produces the following error:
ORA-20987: No columns found for row selector ".". Try to auto-detect or review the JSON structure.
I’ve tried it with the below response uploaded (retrieved from running the POST operation from the main Data Source page, so I know the call is working):
<?xml version="1.0" encoding="UTF-8"?>
<GeteBayOfficialTimeResponse xmlns="urn:ebay:apis:eBLBaseComponents">
<Timestamp>2021-05-19T17:53:14.646Z</Timestamp>
<Ack>Success</Ack>
<Version>1201</Version>
<Build>E1201_CORE_API6_19110890_R1</Build>
</GeteBayOfficialTimeResponse>
and I receive the error:
Server responded with Application Express cannot compute a data profile from the response data of type: . (There’s a period after the error there).
So finally I’ve tried setting it up manually as follows:
Columns:
Name: timestamp
Column Type: Data
Selector: Timestamp
Data Type: Varchar2
Name: ack
Column Type: Data
Selector: Ack
Data Type:Varchar2
But nothing seems to work, where am I going wrong? This should be simple, so I’m missing something obvious.
Thanks in advance, I know I'm going to kick myself when I get a reply.
Rich