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.
277
questions
0
votes
1
answer
60
views
How can I make the SOQL return the "response"?
I'm a newbie.
I have a custom object "transaction__c" and looking in the workbench I have many fields, but doens't show the field "response_c"
, but in the object have him
With this I made a query:
...
- 16
0
votes
1
answer
661
views
JSON_PARSER_ERROR on POST in Workbench
I am using https://workbench.developerforce.com/restExplorer.php . Trying to add new patient, on URL /services/data/v46.0/sobjects/HealthCloudGA__EhrPatient__c, with POST method, with body like this : ...
0
votes
1
answer
132
views
Workbench settings to do only queries
I need workbench connected app to be configured to use only for queries and disable the option to edit single/multiple records
- 1
0
votes
0
answers
220
views
Where are case comments located?
I am looking for the case comments object within Workbench, but I am unable to find where the replies are being stored.
I found the main parent comment located within CommentFeed, and it also shows ...
- 123
2
votes
0
answers
103
views
How to map static date field in Async SOQL query job?
I'm trying to use Aggregate Async SOQL to Query Big Objects to a custom Object like below (https://developer.salesforce.com/docs/atlas.en-us.chatterapi.meta/chatterapi/...
- 1,095
0
votes
1
answer
203
views
Community Plus users are not able to get the attachment using standard salesforce API
We want to get attachment BLOB data using the standard salesforce API. See the API Docs link below.
([https://developer.salesforce.com/docs/api-explorer/sobject/Attachment/get-attachment-id])
We are ...
0
votes
2
answers
345
views
Joining 2 SOQL queries on a relationship that exists uni-directionally from the same object
I'm stuck on this simple dilemma that I was hoping to get answered. I have 3 objects:
Quote
Quote_Year__c
QuoteLineItem
There is a Parent-Child relationship from Quote (Parent) to Quote_Year__c (...
- 121
2
votes
1
answer
18k
views
SOQL to query Custom Labels in Salesforce [closed]
Can anyone suggest me the SOQL which can export custom labels in Salesforce along with its translated texts?
- 131
2
votes
1
answer
2k
views
Inserting of Notes using Workbench
When I try to insert a note using Workbench, I get the following error: "UNKNOWN ERROR: Too many object types to load: 146." with the following fields rendered:
Body
IsPrivate
OwnerID
ParentID
If I ...
- 61
0
votes
1
answer
67
views
Query error but no error showing
I am attempting to use workbench to run a query:
select count(id), Response_CD__c, DAY_ONLY(createddate) from outreach_phone_detail_pd__c where createddate > 2019-10-10T00:00:00Z group by ...
- 65
0
votes
1
answer
2k
views
How can I get information about the current user from Workbench
I'm using Workbench to perform queries.
I would like to get information about the currently logged in user.
In Apex we can use the UserInfo object e.g.
Id userId =UserInfo.getUserId();
User ...
- 1
3
votes
2
answers
3k
views
Can We Create a Change Set via a Package.xml?
Is it possible in Workbench to create a changeset in the target sandbox using a package.xml?
See, we are going to deploy 300 components from a UAT sandbox to a PRE-PROD sandbox without recreating the ...
0
votes
2
answers
631
views
Get ApexCodeCoverageAggregate resultes in CSV
I am using the belwo querying in Query Editor in Developer Console:
SELECT ApexClassOrTrigger.Name, NumLinesCovered, NumLinesUncovered FROM ApexCodeCoverageAggregate
Enabling the Tooling API like ...
- 480
0
votes
1
answer
152
views
Transferring activities associate with accounts to lead
1) On changing the "whoId" of the activities for the conversion of activities associated with the account to lead should we also change the "whoId" field of open activity and activity history too?
2) ...
0
votes
2
answers
444
views
Unable to login into Workbench for any of my Sandboxes
Getting an error when trying to connect to a Sandbox with Workbench.
-2
votes
2
answers
1k
views
I cannot log into workbench
When logging into workbench I receive:
An error has occurred and you have been logged out:
unknown_error: retry your request
- 17
0
votes
1
answer
489
views
Field Permissions History Query
I'm aware on how to run a query on FieldPermissions object to check the permissions for a specific field.
The question I have, and I haven't been able to find anything online yet, is:
If I run the ...
- 1,195
0
votes
1
answer
342
views
Unable to Login to Salesforce workbench
I have signed for a trail licence and want to investigate SOQL function.
When I login into the workbench and select Sandbox it redirects me to test.salesforce.com
I enter my Salesforce credentials it ...
0
votes
1
answer
548
views
Bulk CSV, Bulk XML not working as expected
When trying to query the results in BULK CSV and upon download the file format is .txt and has a query in it instead of the results. Is any step I am missing or is there any bug related to workbench?
...
1
vote
0
answers
24
views
How to truncate CampaignInfluence
CampaignInfluence is consuming a large amount of storage as you can see. Now I've tried to access the object through Workbench etc but no luck. Anyone managed to access the object and do some cleaning ...
- 41
0
votes
1
answer
1k
views
Salesforce Workbench -How to login using a session ID instead of username/password?
I am trying to login to Salesforce using Salesforce Workbench. I want to use the session ID, instead of the usual username/password process.
Any ideas?
- 1
2
votes
1
answer
638
views
how does SOQL compare IDs
This is more of a conceptual question. I was initially querying attachments related to a specific object like this -
SELECT Id, Name, ParentId, Description, BodyLength,IsDeleted,IsPrivate,CreatedById,...
- 555
0
votes
1
answer
24
views
I have one check box field on account which needs to be updated (True)
I have one check box field on account which needs to be updated (True) when i add any notes and attachment in record. I want to implement this functionality via workflow how can i achieve this.
Can ...
- 37
2
votes
1
answer
886
views
Deployment with Workbench - Failure due to special character in process name
I am deploying the components using workbench. One of the components is 'case' object that has got business process named "Complaints & Enquiries". When trying to deploy the package, getting below ...
- 214
1
vote
1
answer
262
views
Issue logging into Salesforce Workbench with custom domain
Does anyone know why I receive an 'invalid_grant: authentication failure' message when I try signing into Salesforce Workbench using a custom domain when I can sign into the custom domain normally? I ...
- 53
0
votes
0
answers
104
views
Payload error while deploy Address settings (State & Country picklists) [duplicate]
Using Workbench i have retrieved the Address setting using package.xml
XML :
<?xml version="1.0" encoding="UTF-8"?>
<Package xmlns="http://soap.sforce.com/2006/04/metadata">
<...
1
vote
0
answers
434
views
Tooling API not retrieving relationship name/label
Querying on Customfield using Tooling API in workbench is returning relationship label "null" even if object has the relationship field(lookup/master-detail).
For Example:
My Object has 3 relationship ...
- 11
0
votes
1
answer
754
views
Is it safe to grant access to Workbench to any user?
Workbench does honor a user's permissions so they cannot do something like set passwords if they do not have that permission, but are there other hazards to granting access to it?
Since it requires ...
- 1,382
5
votes
1
answer
1k
views
SFDX: What is the limit for number of class names under RunSpecifiedTests that can be listed?
Does anybody know what is the limit for the number of class names for RunSpecifiedTests using SFDX? I assume it will be the same limit as when one deploys a change set either using the salesforce's UI ...
- 4,531
0
votes
1
answer
2k
views
Invalid_grant:authentication failure when signing on to Salesforce Workbench
I'm unable to login to Salesforce Workbench using a custom Salesforce domain for Sandbox environment. I'm getting the error invalid_grant:authentication failed. However if i try to sign on to a ...
- 43
2
votes
0
answers
5k
views
Workbench error
When the use the following query:
SELECT Id,Name,Status_vod__c FROM Call2_vod__c
WHERE Status_vod__c = 'Submitted_vod' and LastModifiedDate<= 2017-03-31T23:59:00Z
I get the following error ...
- 21
2
votes
1
answer
161
views
does workbench has access to actual data in the salesforce org
does workbench access actual data in the salesforce org ?
does workbench access only metadata.
specifically does the workbench store the org data in its servers?
- 21
5
votes
1
answer
188
views
Can I use more than one "USING SCOPE" clause?
I am using this query to get a list of old reports in private folders and I am wondering if I can include public folders also. Here is the query:
SELECT Id,name,LastRunDate,owner.firstname,foldername,...
- 51
0
votes
1
answer
192
views
Capturing page performance statistics with Event Monitoring?
I've finished the trailhead for event monitoring. In the trail head it mentions
"Optimize performance — Sometimes it’s hard to determine the cause of slow page performance in your organization. ...
- 99
1
vote
1
answer
1k
views
Capturing Lightning Performance (Page Load Time) without any special tools?
I have been requested to come up with a report or analysis that could "show performance of the page load for a certain period of time or something similar"
Business problem:
Some customers currently ...
- 99
2
votes
2
answers
3k
views
Which IP Ranges has to be whitelisted inorder to use workbench
IP restriction are enabled in our org. when i try to access workbench i get a invalid_IP login error.What range of IP addresses has to be white listed and how safe can white-listing those IP addresses ...
- 21
0
votes
1
answer
1k
views
Tracking who Exports Reports
Yesterday I exported a couple of reports and wanted to track these which has hit the 24hr mark. The following day I went to workbench and through Querying the EventLogFile Object and looking at the ...
- 39
0
votes
1
answer
1k
views
How to get real data from AccountHistory?
when I get data from AccountHistory, including "deleted and archived records", I get all my tracking history.
The problem is that the column Id doesn't match any id in my org.
For example, these two ...
- 1
0
votes
1
answer
798
views
Webservice request from SoapUI not returning results
I am working on an assignment where I need to setup a webservice in Salesforce. The other system will have a search screen on their side and they should be able to search Salesforce for list of ...
- 477
1
vote
1
answer
261
views
Workbench Relationship report
I am using Workbench to show the Child Relationships of objects. Is there any way to have Workbench export that into a spreadsheet ? I'm able to do that when I run a query on records, so I'm wondering ...
- 3,760
1
vote
1
answer
7k
views
SOQL Query Inner Join
Could you please help me with the syntaxis of this SOQL Query? I would like to do an INNER JOIN between A and B on A.FamilyMember=B.ID
SELECT A.FamilyMember__c
FROM A
WHERE A.StartDate__c > TODAY ...
- 1,019
1
vote
0
answers
453
views
An existing Contact could not found with the id 'XXXX'. Confirm both the object type and id are correct
If I try to navigate to any contact like this:
https://workbench.developerforce.com/retrieve.php?id=XXXXX
I get the error:
An existing Contact could not found with the id 'XXXX'. Confirm both the ...
- 111
0
votes
1
answer
267
views
Tasks Updates--Locking issue
We are currently facing issue while updating tasks via dataloader or workbench. We are updating tasks of around 8 lakhs. Problem is tasks are linked to account which locks the accounts while updating ...
- 93
0
votes
1
answer
581
views
Event Owner Details SOQL
I am trying to run a SOQL query in workbench to pull details related to the Event (standard object) owner. I've been able to user Owner.Name within the query but haven't been able to successfully ...
- 67
2
votes
0
answers
130
views
Getting field names from QueryResult when child records are empty - How does Workbench do it?
I'm querying via the REST API (in Apex, because I'm calling another org, amongst other reasons) and using a wacky recursive algorithm on the first returned record to parse out the field names. And no, ...
- 97
1
vote
1
answer
2k
views
Rest Resource URL mapping in workbench
i have written a rest web service class and mapped the resource as '/Accounts/*/contacts'. where * stands for Accountid.
I am trying to do a POST call from workbench and having issue writing server ...
- 287
0
votes
1
answer
2k
views
Report to fetch Duplicate Contacts
I need to generate a report with list of duplicate contacts and their duplicate count. I’m trying to run below query through Data Loader and Workbench & Export the results.
select count(id), ...
- 37
2
votes
1
answer
1k
views
Bulk API 1.0 - use Workbench
How can I use Bulk API 1.0 (for query) with Salesforce Workbench (or Postman) ?
I found that doc explaining Bulk API 1.0 but only with cURL, and I'd like to use Workbench or Postman if possible, but ...
- 1,839
4
votes
0
answers
165
views
"Reached maximum number of custom objects" while creating BigObject
I am trying to create a Big Object through workbench but I keep hitting the following error message:
reached maximum number of custom objects.
I have only used 6% of my custom object allocation ...
- 91
0
votes
2
answers
202
views
Workbench does not perform filter for LongText Area field
In previous release, the possibility to filter by Old value/New Value for history object was introduced.
https://releasenotes.docs.salesforce.com/en-us/summer18/release-notes/...
- 5,417