• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 353
  • Last Modified:

retrieving json from url and dumping into table.

I have API from 3rd party which feeds me data in JSON format.

Ideally, I would like to dump the data into an oracle table. or possibly various tables.

Does anyone have any info on doing this??

1 Solution
easiest method is probably to convert json to xml then use Oracle's xml parsing functions to pull out the fields.

There are java and pl/sql tools for doing json conversion and parsing.
FutureDBA-Author Commented:
The API I am working with has xml option.

your answer set me on a good path.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

7 new features that'll make your work life better

It’s our mission to create a product that solves the huge challenges you face at work every day. In case you missed it, here are 7 delightful things we've added recently to monday to make it even more awesome.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now