Hello,
I've found this: https://stackoverflow.com/questions/27122612/parse-json-into-oracle-table-using-pl-sql
And I want to read a json in the same manner from pl/sql, from an API provided by someone, from an URI, then process the data further. It will have the following structure:
[
{
"art_mgb": 273189,
"var": 1,
"gebi": 1,
"promotion_id": 1018810,
"page_id": 10,
"frame_id": 10,
"user_id": "U871",
"record_status": 1,
"record_unique_id": 1
},
{
"art_mgb": 97404,
"var": 1,
"gebi": 1,
"promotion_id": 1018810,
"page_id": 10,
"frame_id": 10,
"user_id": "U0305223",
"record_status": 1,
"record_unique_id": 2
}
]
But that URI can be accessed with a username and password (in Insomnia for example).
How can I specify the user and password in my pl/sql code, or what is the best way to store it in a hash?
Thanks!