raj-arun

#Decode and Generate CSV File
[xml]$report = Get-Content output.xml
$EncodedString = $report.Envelope.Body.runReportResponse.runReportReturn.reportBytes
$DecodedString = [System.Text.Encoding]::UTF8.GetString([System.Convert]::FromBase64String($EncodedString))
$DecodedString | Out-File "temp.txt"
Import-CSV "temp.txt" -delimiter "," | Export-CSV EPM_Account_Metadata.csv -NoType

raj-arun

<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:v2="http://xmlns.oracle.com/oxp/service/v2">
   <soapenv:Header/>
   <soapenv:Body>
      <v2:getFolderContents>
         <v2:folderAbsolutePath>/Custom/Demo BI/Common</v2:folderAbsolutePath>
         <v2:userID>bi_user_name</v2:userID>
         <v2:password>bi_user_name_password</v2:password>
      </v2:getFolderContents>
   </soapenv:Body>
</soapenv:Envelope>

raj-arun

<soap:Envelope xmlns:soap="http://www.w3.org/2003/05/soap-envelope" xmlns:pub="http://xmlns.oracle.com/oxp/service/PublicReportService">
   <soap:Header/>
   <soap:Body>
      <pub:runReport>
         <pub:reportRequest>	 
            <pub:attributeTemplate>XML_Template</pub:attributeTemplate>
            <pub:reportAbsolutePath>/Custom/INTEGRATION/AP_Invoice_Import_Summary_Report.xdo</pub:reportAbsolutePath>
            <pub:sizeOfDataChunkDownload>-1</pub:sizeOfDataChunkDownload>
         </pub:reportRequest>
      </pub:runReport>

raj-arun

payload = """{
		"schemas":["urn:scim:schemas:core:2.0:User"],
		"name":{"familyName":"Raj",
			"givenName":"Arun"
			},
		"active":true,
		"userName":"araj@quest4apps.com",
		"emails":[{"primary":true,"value":"araj@quest4apps.com","type":"W"}],
		"displayName":"Arun Raj",

raj-arun

users = response.json()

print("List of users : \n")

# Loop through the response and print the details
for user in users["Resources"]:
    print("User Name : {}".format(user["userName"]))
    print("Display Name : {}".format(user["displayName"]))
    print("Active : {}\n".format(user["active"]))

raj-arun

import requests
from requests.auth import HTTPBasicAuth
import os

user_name = 'domain_name.user_name'
password = 'your_password'

            
def read_in_chunks(file_object, chunk_size):
    while True:

raj-arun

<soap:Envelope xmlns:soap="http://www.w3.org/2003/05/soap-envelope" xmlns:pub="http://xmlns.oracle.com/oxp/service/PublicReportService">
   <soap:Header/>
   <soap:Body>
      <pub:runReport>
         <pub:reportRequest>
		<pub:parameterNameValues>
			<pub:item>
				<pub:name>P_YEAR</pub:name>
				<pub:values>
					<pub:item>2019</pub:item>

raj-arun

<soap:Envelope xmlns:soap="http://www.w3.org/2003/05/soap-envelope" xmlns:pub="http://xmlns.oracle.com/oxp/service/PublicReportService">
   <soap:Header/>
   <soap:Body>
      <pub:runReport>
         <pub:reportRequest>
		<pub:parameterNameValues>
			<pub:item>
				<pub:name>P_YEAR</pub:name>
				<pub:values>
					<pub:item>2019</pub:item>

raj-arun

<soap:Envelope xmlns:soap="http://www.w3.org/2003/05/soap-envelope" xmlns:pub="http://xmlns.oracle.com/oxp/service/PublicReportService">
   <soap:Header/>
   <soap:Body>
      <pub:runReport>
         <pub:reportRequest>
		<pub:parameterNameValues>
			<pub:item>
				<pub:name>P_YEAR</pub:name>
				<pub:values>
					<pub:item>2019</pub:item>

raj-arun

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>)