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!

APEX 18.2 - Websource module not parsing returned JSON data

User_VNNOWNov 27 2018 — edited Jan 8 2019

I was excited about using websource modules to consume JSON formatted data and parse it w/o having to write code but came across a strange issue. I'm on APEX 18.2.0.00.12 with a 12.1.0.2 database. The web sourced module does indeed return the JSON data but does not parse the value. I've tested against another web service with the same data that works

perfectly using apex.oracle.com but not with my environment. Interestingly, I am able to parse the value using APEX_JSON functions via sql with no issue. I was hoping to leverage the features of APEX 18 to avoid coding. Screenshots below along with the debug output from APEX. Any ideas? ScreenBlackOut.png

Response Body

{"events":287956046}

pastedImage_1.png

pastedImage_0.png

Comments
Post Details
Added on Nov 27 2018
8 comments
1,395 views