Questions tagged [workbench]
A web-based suite of tools designed for administrators and developers to interact with Salesforce.com organizations via the Force.com APIs.
186
questions
0
votes
1answer
57 views
mass field creation & migration
Actually, I already have a salesforce org where I have some custom objects & fields. Now I want to create the same objects and fields(including checkbox, formula fields nearly 100) in another org. ...
1
vote
2answers
332 views
how to deploy file with brackets in the name using workbench/ant package xml
I have to profile layouts named with brackets in the name.
When retrieved the package xml have them listed as:
<members>My layout (version 1)</members><br/>
and the content of the ...
1
vote
1answer
418 views
not being able to query BusinessHours in Case object
I have set up Business Hours in my org. A field called BusinessHours appears in the Case Standard field List. However as soon as I try to query using workbench, it throws an error
select ...
0
votes
2answers
2k views
Permission Set Assignment report
Is it possible to make a report which would show the assignees of a bunch of Permission Sets ? I'm guessing the only way to do it would be to build a report based upon the PermissionSetAssignment ...
4
votes
1answer
420 views
WHERE clause in SOQL query to history object (to custom field)
I am querying in the Workbench with SOQL.
I need to query a history object to a custom field, but I want to see changes only to a certain field. What is the syntax to say WHERE Field = MyTargetField ?
...
6
votes
1answer
820 views
How to mass undelete data from recycle bin
I have mistakenly deleted 200,000 records in the recycle bin and am trying to recover them. Although, clicking undelete button 1000 times might be a good way of remembering the mistake, it is still a ...
0
votes
0answers
838 views
insufficient access rights on cross-reference id while deploying package
I am getting below error while deploying package.
Insufficient access rights on cross-reference id.
I can't even see line number.so I am not able to find issue. Please suggest
1
vote
2answers
2k views
Bulk API: using Workbench InvalidSessionId (Unable to find session id)
I'm following this (Bulk Api) Trailhead, I have valid SessionId and when I try to authenticate I'm getting the following error:
I have created few records using the same SessionId and I know its a ...
1
vote
1answer
619 views
Can't deploy reports with workbench
I've retrieved some reports from my org, made changes to them and am trying to deploy them again through workbench. Everything went well until I try to deploy my zipped directory containing the ...
2
votes
1answer
1k views
apex REST WEB SERVICE : Unexpected parameter encountered during deserialization: startdate at
I have a few json's that I'm posting with the access-token as header, when I send two parameters I get a status message from my rest api successfully, but when I send more than 2 parameters I get the ...
11
votes
1answer
3k views
Difference between data loader and workbench
I uploaded a .csv file with 50000 rows to the Salesforce Workbench to update a custom field in Opportunities. For most records I got the error
Too many lock failure 200 Trying again later.
I ...
1
vote
0answers
762 views
How to export data queried from nested loop soql query
I need to export data by using nested loop query.Both workbench and data loader does not allow to export data queried from nested loop.Is there any way to export nested loop queried data.
4
votes
2answers
822 views
How to get a record in workbench by passing record name with out using rest class
I knew that we can get record by passing id of a record in workbench and we can get a record by passing name of a record(using where condition) by using rest class.
But i want to know that,
(I ...
1
vote
0answers
32 views
Report on which users have granted login access to Administrator
I know how to grant login access to administrator/salesforce. What I want to know is in which object is this setting stored? I want to do reporting on all the users in my org who have granted access ...
1
vote
1answer
303 views
How to retrieve and deploy translations in salesforce?
I want to deploy some traslations made via workbench , i made the following XML file to retrieve the modifications (the field is a picklist called Type under Event object), but it does not work, the ...
0
votes
1answer
506 views
How to export a Report with large amount of records
I have a report of custom report type in unlimited edition with 3000 records, When I try to export,customize or run the report. The data is not showing up. It is giving the message like the report is ...
0
votes
1answer
5k views
unable to obtain exclusive access to this record
I am getting below error on a custom field on the Account object during deployment.
unable to obtain exclusive access to this record
Why am I getting this error?
0
votes
3answers
2k views
Migration of Standard Object Permissions using meta data deploy
I am trying to migrate object permissions using metadata deploy in workbench.I am facing an issue - although I have explicitly stated the standard object in package.xml, the object permissions are not ...
3
votes
1answer
433 views
Is the OpportunityShare.RowCause available for changes through the API?
According to the documentation on OpportunityShare about RowCause:
You can create a value for this field in API versions 32.0 and later
with the correct organization-wide sharing settings.
...
0
votes
1answer
1k views
How can I export Info data from Workbench [duplicate]
I would like to export the file data from the Info section in Workbench. I am particularly interested in capturing Created By and Changed By data for certain metadata components. Any ideas on how I ...
3
votes
1answer
589 views
Workbench - Picklist Value is translated but still in english language for Users
I've translated the status picklist values into portuguese in the parent object, but the user still seeing the picklist option in english language in the child object. The workbench option is ...
2
votes
2answers
56 views
Get single emails sent / Single email limit number to create alert when approaching the limit
My organization sends emails via Apex single email in some cases,
We are sending the mails to users whenever possible, but sometimes we need to send to external mail, that's causing us to use the 1000 ...
0
votes
1answer
598 views
How to get a rich text area content without HTML markups
While doing an SOQL query, I am getting html tags for Rich Text fields. Is there possibility to get only the rich text area content without the HTML markups in the query itself?
0
votes
2answers
580 views
Invalid cross reference Error: Record Type ID: This ID Value Isn't Valid For The User:
While inserting data, though I do provide exact RecordTypeID by querying on workbench, I am unable to load only left with below error.
Can someone please help?
Record Type ID: This ID Value Isn't ...
4
votes
2answers
3k views
Did the session id value disappear from the workbench?
I remember that the session information menu option used to display a session id value in the workbench? Is that no longer visible?
I can still get this by executing this line of code in the Apex ...
1
vote
2answers
56 views
Backup my org all the customisation or create an image
I have to backup all my Salesforce org customization . Is it possible to backup or create an image or both my Salesforce org customization with the reports and dashboards of the org.
Also , is it ...
0
votes
1answer
2k views
Workbench deploy
I have retrieved the unmanaged package using workbench from one org and have to deploy the that in another org .
I'am directly deploying the retrieved package by just logging into another org using ...
0
votes
1answer
529 views
How to use AND in workbench REST explorer
Say I have a query that looks like
/services/data/vXX.0/query/?q=SELECT+Name+From+Account+WHERE+ShippingCity='San+Francisco'
how would I add a condition like zip=XXXXXto this query? I tried using &...
3
votes
2answers
5k views
How to consume a soap web service using workbench?
I would like to call a SOAP web service created in salesforce, using Workbench. There are some samples for other types of web services from the apex workbook but not for SOAP :-(
My class contains 2 ...
1
vote
2answers
270 views
What happen with all the data after app provider quit
I am using 3 apps from a company which recently decided to go out of business. They have given 31 June last day after that they will remove their apps.
I am really worried now as I have no enough ...
2
votes
1answer
856 views
How to get the Available Record Types by Profile for a STANDARD Object
I found this post (especially Adam Torman's comment) really helpful in getting to the most elusive element of a profile--which record types are assigned to it for creation:
Available Record Type by ...
1
vote
2answers
468 views
Is there a way to check a field's accessibility through API
The standard field Email on CampaignMember object is not available through API, for which we use the workaround of having another custom field so that its accessible through API.
Is there any way to ...
0
votes
0answers
499 views
how to give request uri to access http put method without using apex class in workbench and postman
enter image description here
Put Method is Not working for any Requests whereas all Methods are Working Good can anyone Please guide me for the Answer
0
votes
2answers
319 views
Workbench download results in csv
I need to find out that is it possible to schedule daily csv download of records from Workbench .
3
votes
1answer
162 views
Unknown Error in Workbench while querying UserEntityAccess
Getting Unknown Exception while querying 'UserEntityAccess' in work bench,
Query :
SELECT
EntityDefinition.Id,EntityDefinition.DurableId,
EntityDefinition.QualifiedApiName, EntityDefinition....
1
vote
1answer
266 views
Is there a bug on the when querying the FieldHistoryArchive table?
Is there a bug on the when querying the FieldHistoryArchive table?
Background:
The FieldHistoryArchive table is neither available from dataloader nor dataloader.io
So I had to go with Workbench on ...
5
votes
1answer
4k views
SOQL: No response from the server error
I have below query to run either in workbench or Developer console, query editor.
While on workbench, I get error: UNKNOWN ERROR: Error Fetching http headers
and in Developer console error as No ...
0
votes
2answers
46 views
workbench SOQL query problem
searchcon = [select id,MailingPostalCode,Name,Phone
From Contact
where Name = :string1
or MailingPostalCode = :string2
limit 10];
from ...
3
votes
2answers
1k views
Using Workbench to deploy destructive change set to eliminate apex class in production
I ran into an Apex Class error while trying to deploy a vendor package in Production from our partial Sandbox. The Apex class is obsolete and we have decided to delete it.
Not having any developer ...
1
vote
1answer
63 views
Issue with Event Log file. Users activities related to Dashboard view are not recorded in Salesforce
We have Enabled Event log for our organization and it was working absolutely fine but since last month Sales profile Dashboard view activities do not record in event log. I queried event log used ...
0
votes
1answer
339 views
Getting error code malformed_query when tried to query eventlog through REST in workbench
I tried to query Dashboard activity from event log. So I am using workbench and tried to pull it but getting error code malformed_query.
I am using REST explorer and my query is
/services/data/v35....
3
votes
1answer
1k views
SOQL Query not returning results for Oldvalue/Newvalue in workbench
I have a query as below:
SELECT CaseId,CreatedById,CreatedDate,Field,Id,IsDeleted,NewValue,OldValue FROM CaseHistory
In my query NewValue,OldValue not getting in workbench.But same query working ...
0
votes
1answer
209 views
Is there any way to modify Standard profile
I am trying to provide some permissions to objects in Read Only standard profile.
Using UI i am not able to change the object permissions.
Is there any way i can achieve it?
1
vote
1answer
1k views
Enabling Workbench in sandbox
We have three sandboxes attached to production.Would enabling workbench in one sandbox effects other non prod enviorment also.
Can it be possible we enable it for one sandbox and other two sandboxes ...
1
vote
1answer
108 views
Workbench doesn't show API version beyond 35.0
As per the known issue:
https://success.salesforce.com/issues_view?id=a1p300000008dNiAAI
This feature would be available only for version 36 (and not below 36, once the known issue is fixed). ...
1
vote
1answer
874 views
Inserting Multiple Records into a custom object which has a reference to another object
I have the following REST webservice for inserting multiple records into a custom object Tickets.
@RestResource(urlMapping='/MultiTicket/*')
global with sharing class MultiTicketRestController{
...
3
votes
1answer
3k views
Cannot deserialize instance of datetime from VALUE_STRING value
I have a REST webservice which inserts multiple records into custom objects. I am executing it on workbench using the following request:
{"req" : {"tickets": [{
"External_TicketID__c" :1853,
"...
3
votes
1answer
605 views
Query 4 levels and get bulk csv from workbench
I'm hoping this is an easy one but I'm having no luck in developer console or workbench.
I have an object called Order_Line_Item__c that is related to Order__c which is related to Opportunity which ...
1
vote
1answer
60 views
I need to update a multi-value picklist field with multiple values through workbench
I need to update a multi-value picklist field with multiple values through workbench. I have tried using semi-colon between the values but have received an error that "
You May Only Select One ...
4
votes
1answer
2k views
How do I use the WorkBench to retrieve metadata?
I'm trying to figure out how to retrieve Field Audit Trail metadata using the WorkBench, and I'm stumped. I used the WorkBench to deploy a zip file named package-Dev.zip, which contained the following ...
