I have a component that dynamically replicates a page layout . Im querying the ProfileLayout object to get the layout JSON, this works fine when i run as a sys admin, but fails when executed as a non-admin, getting this response:
{"message":"sObject type 'ProfileLayout' is not supported.","errorCode":"INVALID_TYPE"}
this is the query:
string query = 'select Layout.Name from ProfileLayout where ProfileId = \'' + UserInfo.getProfileId() + '\'';
Is there any way to achieve this?
I replicated your jsForce test in a Visualforce page with:
<apex:page docType="html-5.0" showHeader="false">
<script src="//cdnjs.cloudflare.com/ajax/libs/jsforce/1.4.1/jsforce.min.js"></script>
<script>
var apexBody = "<" + "apex:page standardController=\'Account\'>Test" + "<" + "/apex:page>";
var conn = new jsforce.Connection({ accessToken: '{!$API.Session_Id}' });
conn.tooling.sobject('ApexPage').create({
Markup: apexBody,
Name: "PageTest",
Masterlabel: "PageTestLabel",
ControllerType: "1",
ApiVersion: "33.0"
}, function(err, res) {
if (err) { return console.error(err); }
console.log(res);
});
</script>
</apex:page>
Note that I added ControllerType with the value of 1 based on Creating Visualforce Page Using Tooling API.
This resulted in a POST request to https://mynamespace.na17.visual.force.com/services/data/v33.0/tooling/sobjects/ApexPage
With the headers:
Payload:
{"Markup":"<apex:page standardController='Account'>Test</apex:page>","Name":"PageTest","Masterlabel":"PageTestLabel","ControllerType":"1","ApiVersion":"33.0"}
I received the same 400 Bad Request response that you did:
[
{
"message": "Object type not accessible. Please check permissions and make sure the object is not in development mode: sObject type 'Account' is not supported.. Original queryString was: 'SELECT Id FROM Account WHERE id = '000000000000000'': Markup",
"errorCode": "FIELD_INTEGRITY_EXCEPTION",
"fields": [
"Markup"
]
}
]
Out of interest, I created the ApexPage directly in the Salesforce UI and then retrieved the resulting JSON definition via the Tooling API.
{
"attributes": {
"type": "ApexPage",
"url": "/services/data/v33.0/tooling/sobjects/ApexPage/066o0000002eacAAAQ"
},
"Id": "066o0000002eacAAAQ",
"NamespacePrefix": "DF14DFB",
"Name": "PageTest",
"ApiVersion": 33,
"MasterLabel": "PageTestLabel",
"Description": null,
"ControllerType": "1",
"ControllerKey": "Account",
"IsAvailableInTouch": false,
"IsConfirmationTokenRequired": false,
"Markup": "<apex:page standardController=\"Account\">Test</apex:page>",
"CreatedDate": "2015-07-06T20:43:55.000+0000",
"CreatedById": "005o0000001V9OXAA0",
"LastModifiedDate": "2015-07-06T20:44:53.000+0000",
"LastModifiedById": "005o0000001V9OXAA0",
"SystemModstamp": "2015-07-06T20:44:53.000+0000"
}
Stripping out the Dates etc... and changing the Name I still got the original error POSTing this back to create a new ApexClass.
So I'd conclude that this is a bug in the Tooling API. Especially as it works if the standardController isn't defined.
Previously I'd encountered problems with the Tooling API where it couldn't create the initial records (See How do I use the Tooling API to create a new Apex Trigger?). You may need to create the New ApexClass using the standard REST API rather than the Tooling API.
I suspect you just want a normal SOQL query rather than a Tooling API query.
The following ran against the SOAP Partner API no problem.
Select Id, Name From ProcessDefinition
It also worked in the Developer Console, which means it was executed against the REST API.
See also:
Update for subsequent question
To get the Entry Criteria for the approval process you will need to go to the Metadata API. See ApprovalProcess and the associated entryCriteria of type ApprovalEntryCriteria.
Getting to that in Apex will require a bit of work. You could try the Apex Wrapper Salesforce Metadata API. There is also the official Apex Metadata API, but that doesn't have access to the approval processes yet (as at Summer '17). Try raising the use case in the success community or as an idea.
Best Answer
The describe call you're apparently looking for is:
This will give you all the layout information need for a given record type and object type. This call is available for all users so long as they have any API access.