---
title: "Discussion on \"Stop Writing JSON_TABLE SQL Manually #JoelKallmanDay\" | Hashnode"
description: "Discussion on \"Stop Writing JSON_TABLE SQL Manually #JoelKallmanDay\". Introduction\nOne of my favorite things to do with APEX is to integrate REST APIs. Whether that means building one with ORDS, or consuming one, I love working with REST APIs because they can easily extend the functionality of your app or allow you to ..."
url: "https://hashnode.com/posts/stop-writing-jsontable-sql-manually-joelkallmanday/63462382371493a162ee06e9"
---

[Feed](https://hashnode.com/feed) /

Discussion

# [Stop Writing JSON\_TABLE SQL Manually #JoelKallmanDay](https://haniel.hashnode.dev/stop-writing-jsontable-sql-manually-joelkallmanday?utm_source=hashnode&utm_medium=feed)

Introduction One of my favorite things to do with APEX is to integrate REST APIs. Whether that means building one with ORDS, or consuming one, I love working with REST APIs because they can easily extend the functionality of your app or allow you to ...

Oct 12, 2022 · 4 min read · haniel.hashnode.dev  
Updated Oct 14, 2022  
Read the article

-   [#oracle](https://hashnode.com/tag/oracle)
-   [#oracle-apex](https://hashnode.com/tag/oracle-apex)
-   [#apex-tips](https://hashnode.com/tag/apex-tips)
-   [#apexworld](https://hashnode.com/tag/apexworld)
-   [#orclapex](https://hashnode.com/tag/orclapex)

## Written by

[Haniel Burton](https://hashnode.com/@Haniel)

@Haniel · Oklahoma, US

  
[View profile](https://hashnode.com/@Haniel)

Senior Oracle APEX Developer @Insum

I'm a Senior APEX Programmer Analyst at Insum. Passionate about using Oracle Database and APEX to build kickass apps.

## Responses 2

Markdown supported · ⌘↵ to post

[Plamen Mushkov](https://hashnode.com/@plamen9)

[Oct 17, 2022](https://hashnode.com/posts/stop-writing-jsontable-sql-manually-joelkallmanday/63462382371493a162ee06e9/comment/634d8dda04eabc81632209d5)

Great effort to build that view Haniel! Thanks for sharing!

I noticed it's not always possible to get the Profile, as `apex_data_parser.get_file_profile` is not available on apex.oracle.com for example (getting `ORA-06502: PL/SQL: numeric or value error`). Also the view couldn't compile for me (and couldn't run its statement) even on an environment I could read the file profile.

[Haniel Burton](https://hashnode.com/@Haniel)

[Oct 21, 2022](https://hashnode.com/posts/stop-writing-jsontable-sql-manually-joelkallmanday/63462382371493a162ee06e9/comment/634d8dda04eabc81632209d5#reply-6352dd13ee1517c87af5fff8)

Hi Plamen, thanks for letting me know you were having issues with it. Let me test this weekend and get back to you.

I wonder why get\_file\_profile isn't available on apex.oracle.com.

[Louis Moreaux](https://hashnode.com/@lmoreaux)

[Oct 12, 2022](https://hashnode.com/posts/stop-writing-jsontable-sql-manually-joelkallmanday/63462382371493a162ee06e9/comment/634659b06cd3e81ff0320e69)

Excellent post Haniel, thanks for sharing!
