Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

HELP: eBay API - array of JSON objects to local table

yoursales24Jan 15 2021

Hi,
I have a working REST Data Source in Apex 20.2 which gets our eBay orders of buyers as a JSON response.
developer.ebay.com/api-docs/sell/fulfillment/resources/order/methods/getOrders
Unfortunately, the items come in an array which contains the details for all line items that comprise the order.

"orders":[ 
 { 
 "lineItems": [
   {
     "lineItemId": "123",
   },
   {
     "lineItemId": "456",
   }
 ]
 }
]

One Buyer with one item - works fine. But for buyers with multiple purchases the loaded local table shows NULL for the items.
I think I have to parse the data, right? But how and can it be done in REST Data Source by fetching it into the table?
Thank you for any help you can offer.
Br, Chris

Comments
Post Details
Added on Jan 15 2021
2 comments
146 views