Salesforce: Object records BatchGet to Table<\/div>
Gets target object record times and stores items in a Table-type Data Item.<\/div><\/div>\n\n\n
<\/span>Configs<\/div>
\n
- \n
- A: Select HTTP_Authz (OAuth2) *<\/span><\/li>\n
- <\/i><\/span> B: Set Sub-Domain (https:\/\/<\/a>{subdomain}.salesforce.com\/) *<\/span><\/li>\n
- <\/i><\/span> C: Query for Salesforce API Query *<\/span>#{EL}<\/sup><\/span><\/li>\n
- D: Select LIST DATA (update) *<\/span><\/li>\n
- <\/i><\/span> E: EDIT String for json top level key name eg. records *<\/span><\/li>\n
- <\/i><\/span> F: json key\/Table Column Field Name eg.CaseNumber:Number,… *<\/span><\/li>\n
- G: Select STRING DATA for Access Log (update)<\/li>\n
- H: Select Decimal DATA for Records Count (update)<\/li>\n<\/ul>\n<\/div><\/div>\n\n\n
<\/span>Script (click to open)<\/div>\n\n\n\n\/\/ GraalJS Script (engine type: 2)\n\/\/ Batch to Get Accounts from Salesforce via Salesforce REST API (ver. 50, Winter'21)\n\/\/\n\/\/ OAuth2 config\n\/\/ Authorization Endpoint URL: https:\/\/login.salesforce.com\/services\/oauth2\/authorize\n\/\/ Token Endpoint URL: https:\/\/login.salesforce.com\/services\/oauth2\/token\n\/\/ Scope:\n\/\/ Consumer Key: (Get by Salesforce Connected App screen)\n\/\/ Consumer Secret: (Get by Salesforce Connected App screen)\n\n\n\/\/\/\/\/\/\/\/ START "main()" \/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\nmain();\nfunction main(){\n\n\/\/\/\/ == \u5de5\u7a0b\u30b3\u30f3\u30d5\u30a3\u30b0\u306e\u53c2\u7167 \/ Config Retrieving ==\nconst oauth2 = configs.get( "conf_OAuth2" ); \/\/required\nconst subDomain = configs.get( "conf_SubDomain" ); \/\/required\nconst strQuery = configs.get( "conf_Query" ); \/\/required\nconst objectList = configs.getObject( "conf_DataIdD" ); \/\/required\nconst strTopKey = configs.get( "conf_DataIdE" ); \/\/required\nconst strConfigJsonPaths = configs.get( "conf_DataIdF" ); \/\/required\nconst strResponse = configs.getObject( "conf_DataIdG" );\nconst decRecordCount = configs.getObject( "conf_DataIdH" );\n\n\n\/\/\/\/ == \u30ef\u30fc\u30af\u30d5\u30ed\u30fc\u30c7\u30fc\u30bf\u306e\u53c2\u7167 \/ Data Retrieving ==\n\/\/ (Nothing. Retrieved via Expression Language in Config Retrieving)\n\n\n\/\/\/\/ == \u6f14\u7b97 \/ Calculating ==\nconst uri = "https:\/\/" + subDomain + ".salesforce.com\/services\/data\/v50.0\/query\/";\nconst response = httpClient.begin()\n.authSetting(oauth2)\n.queryParam("q", strQuery)\n.get(uri);\nengine.log( " AutomatedTask ApiRequest Start: " + uri );\n\nconst responseCode = response.getStatusCode() + ""; \/\/ (primitive string);\nconst responseBody = response.getResponseAsString() + "";\nengine.log( " AutomatedTask ApiResponse Status: " + responseCode );\nif( responseCode !== "200" ){\nthrow new Error( "\\n AutomatedTask UnexpectedResponseError: " +\nresponseCode + "\\n" + responseBody + "\\n" );\n}\n\nif( strResponse !== null){\nengine.setData( strResponse, responseBody );\n}\n\nconst objJsonText = JSON.parse( responseBody );\n\/\/ set key for getting data\nconst arrStrConfigJsonPaths = strConfigJsonPaths.split(",");\nlet arrJsonPathValues = new Array(objJsonText[strTopKey].length);\nengine.log( " AutomatedTask: # lenght of arrJsonPathValues: " + arrJsonPathValues.length );\n\/\/ setup List Type data item\nlet table = engine.findData(objectList);\ntable = objectList.createListArray();\n\/\/engine.log("responseBody: " + responseBody );\n\/\/ parse json\nfor (let i=0; i < objJsonText[strTopKey].length; i++){\narrJsonPathValues[i] = new Array(arrStrConfigJsonPaths.length);\nlet row = table.addRow();\nfor (let j=0; j < arrStrConfigJsonPaths.length; j++){\nlet strConfigJsonPathAndCol = arrStrConfigJsonPaths[j].split(":");\nlet arrSubKey = strConfigJsonPathAndCol[0].split(".");\nlet obj = objJsonText[strTopKey][i];\nfor (let k=0; k < arrSubKey.length; k++){\nobj = obj[arrSubKey[k]];\n}\nif (obj === null){\narrJsonPathValues[i][j] = "";\n}else{\narrJsonPathValues[i][j] = obj;\n}\n\/\/ engine.log("arrJsonPathValues[" + i + "][" + j+ "]" + arrJsonPathValues[i][j]);\nrow.put(strConfigJsonPathAndCol[1] , arrJsonPathValues[i][j].toString() );\n}\n}\n\n\/\/\/\/ == \u30ef\u30fc\u30af\u30d5\u30ed\u30fc\u30c7\u30fc\u30bf\u3078\u306e\u4ee3\u5165 \/ Data Updating ==\n\/\/ \u30c6\u30b9\u30c8\u7528\u30ed\u30b0\u8868\u793a\nfor (let i=0; i < arrJsonPathValues.length; i++){\nfor (let j=0; j < arrJsonPathValues[i].length; j++){\nengine.log("arrJsonPathValues[" + i + "][" + j + "]=" + arrJsonPathValues[i][j] );\n}\n}\nengine.setData(objectList, table);\nengine.setData(decRecordCount, new java.math.BigDecimal(objJsonText[strTopKey].length) );\nif( strResponse !== null){\nengine.setData( strResponse, responseBody );\n}\n\n} \/\/\/\/\/\/\/\/ END "main()" \/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\n\n<\/code><\/pre><\/div>\n\n\n<\/div><\/div>\n\n\n\n<\/a><\/figure>\n\n\n\n
<\/i> Download<\/h3>\n\n\n\n
- Salesforce-Object-BatchGet-to-table-202208.xml<\/a><\/li><\/ul>\n\n\n\n
2022-08-02 (C) Questetra, Inc. (MIT License)
https:\/\/support.questetra.com\/addons\/salesforce-object-batchget-to-table-202208\/<\/a>
<\/i> The Addon-import feature is available with Professional<\/strong><\/span> edition.
Freely modifiable JavaScript (ECMAScript) code. No warranty of any kind.<\/p>\n\n\n
- <\/i><\/span> B: Set Sub-Domain (https:\/\/<\/a>{subdomain}.salesforce.com\/) *<\/span><\/li>\n
![\"\"](\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2022\/09\/salesforce-object-records-settings.jpg?ssl=1\")
<\/figure>\n\n\n\n