How to Reference G_1 Dataset output in G_2 Dataset

Oracle OTBI -> Most Recent version

In my custom data model I have two data sets, G_1 is a HTTP (XML Feed) and G_2 is a simple SQL Query select PARTY_ID from HZ_PARTIES.

My Data output is as follows:

I understand HTTP (XML Feeds) should ideally return an XML response from my HTTPS url:

<myOracleServer>/fscmRestApi/resources/11.13.18.05/payablesPaymentTermsLOV

HOWEVER, I am getting a ton of useful JSON data from calling that webservice in my data model and I would love to be able to use it in a BiPublisher Report

So can I reference G_1 data ( data output Data_DS -> Oracle_Rest which is the name of G_1) in G_2 so that I could access and parse my JSON Data with SQL commands to parse/modify JSON in G_2 so that the data is accessible for my BiPublisher report?