This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
{ | |
"aggregateEssbaseData": true, | |
"dataGrid": { | |
"rows": [ | |
{ | |
"headers": [ | |
"OFS_Salaries" | |
], | |
"data": [ | |
"110.00", |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
{ | |
"exportPlanningData": false, | |
"gridDefinition": { | |
"suppressMissingBlocks": true, | |
"pov": { | |
"dimensions": [ | |
"Movement", | |
"Years", | |
"Period", | |
"Data Source", |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
+------------------------+-------------------------------------------+ | |
| Name | Description | | |
+------------------------+-------------------------------------------+ | |
| gridDefinition | JSON grid definition to define the region | | |
| exportPlanningData | True or false. Default is False | | |
| suppressMissingBlocks | True or false. | | |
| suppressMissingRows | True or false. | | |
| suppressMissingColumns | True or false. | | |
+------------------------+-------------------------------------------+ |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:v7="urn://oracle.bi.webservices/v7"> | |
<soapenv:Header/> | |
<soapenv:Body> | |
<v7:fetchNext> | |
<v7:queryID>RSXS8_1</v7:queryID> | |
<v7:sessionID>kqit1vtind5f48rl5tmlgeqois397go92iic5nrgl8litlfs</v7:sessionID> | |
</v7:fetchNext> | |
</soapenv:Body> | |
</soapenv:Envelope> |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:v7="urn://oracle.bi.webservices/v7"> | |
<soapenv:Header/> | |
<soapenv:Body> | |
<v7:executeXMLQuery> | |
<v7:report> | |
<v7:reportPath>/shared/custom/AR/Customers</v7:reportPath> | |
<v7:reportXml>?</v7:reportXml> | |
</v7:report> | |
<v7:outputFormat>?</v7:outputFormat> | |
<v7:executionOptions> |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:v7="urn://oracle.bi.webservices/v7"> | |
<soapenv:Header/> | |
<soapenv:Body> | |
<v7:logon> | |
<v7:name>username</v7:name> | |
<v7:password>password</v7:password> | |
</v7:logon> | |
</soapenv:Body> | |
</soapenv:Envelope> |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
Method | Service | Description | |
---|---|---|---|
logon | SAWSessionService | Login and create a session | |
executeXMLQuery | XmlViewService | Execute Query | |
fetchNext | XmlViewService | Fetch next set of records |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
import requests | |
url = "https://hostname/interop/rest/v1/services/sendmail" | |
payload='to=user%40example.com&subject=Email%20from%20REST%20API&body=some%20body%20test&attachments=Metadata.xlsx' | |
headers = { | |
'Authorization': 'Basic YTY2ODE5NC5BcnVuLlN1cmVuZHJhbkBiYWtlcnRpbGx5LmNvbTpWY2lfYXJjc18wMDc=', | |
'Content-Type': 'application/x-www-form-urlencoded' | |
} |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
SELECT | |
TDS.NAME DATA_SOURCE_NAME | |
, TDS.DYNAMIC_TABLE_NAME | |
, 'C_'||TDSA.DATA_SOURCE_ATTRIB_ID COLUMN_NAME | |
FROM | |
TM_DATA_SOURCE TDS | |
, TM_DATA_SOURCE_ATTRIB TDSA | |
WHERE | |
TDS.RECON_TYPE_ID = TRT.RECON_TYPE_ID | |
AND TDSA.DATA_SOURCE_ID = TDS.DATA_SOURCE_ID |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
SELECT | |
TRT.NAME MATCH_TYPE_NAME | |
, TDS.NAME DATA_SOURCE_NAME | |
, TDS.DYNAMIC_TABLE_NAME | |
FROM | |
TM_DATA_SOURCE TDS | |
,TM_RECON_TYPE TRT | |
WHERE | |
TDS.RECON_TYPE_ID = TRT.RECON_TYPE_ID | |
AND UPPER(TRT.NAME) = UPPER(<Match Type Name>) |
NewerOlder