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.

Filter by
Sorted by
Tagged with
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: ...
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 (...
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 ...
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 ...
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
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 ...
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,...
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 ...
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 ...
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 ...
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 ...
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,...
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. ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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