API endpoint (optional)




Salesforce SOQL, SOSL and Apex

Run queries against any org

If you are an admin or a developer, this tool will make your life easier. You will be able to query your data and run productive commands against your production org, sandbox, developer org or even preview org.
You just need to login (standard secured Salesforce oAuth flow) and then any request will be managed directly between your browser and Salesforce org.
If you do not whitelist www.adminbooster.com domain, you will have to define a proxy to run your queries, you can configure https://proxy.adminbooster.com or your own proxy. It is still more secure and performant to whitelist the domain than to use a proxy.
Your profile must be "API Enabled" to use this tool and "Author Apex" to run Apex code with this tool
Click the help icon to see the list of available commands.
X

Tips

  • Editor: use Ctrl+Enter instead of clicking on the "Run" button
  • Query:
    • You can display cross objects parent field values.
      Ex: select name,owner.name from account
    • If a "Select" is returning aggregate values, a graph is automatically displayed
      Ex: select count(id) qty,status from case group by status
  • URL # parameters: use both "access_token" and "instance_url" to bypass the login process
    Ex: https://www.adminbooster.com/tool#access_token=00Dxxx...&instance_url=https%3A%2F%2F...
  • URL # parameters: use both "client_id" and "redirect_uri" to use your own Connected App for the oAuth flow
  • URL # parameters: use "listing" to pre-load a listing saved on the server
  • Use the scratch pad to copy/paste (or select+drag+drop) from and to the query editor. ScratchPad data is persistent and will remain next time you access the tool.
  • If you whitelist this website instead of using adminbooster proxy, you will have a 100% secure access to your data: only between your browser and your Salesforce instance. Adminbooster server is never involved to access your data. The access token retrieved by the authentication flow is NOT sent over the network to the server (only to your browser).
  • You can develop and use your own proxy. Target instance domain name will be set in "X-Host" http header. Proxy url can be predefined in the url through a # named parameter (proxy).
    Ex: https://www.adminbooster.com/tool#proxy=https%3A%2F%2Fyourdomain
  • Quick access to the Playground with this bookmarklet:
X

About

Adminbooster Playground has been developed by © Jean-Luc Antoine.
  • YOU CAN:
    • Use this tool for free, at any time.
    • Make links to this page; the more it will be used, the more features I will add.
    • Tell me if you find any bug, I will try to correct them; you need to detail the steps to reproduce it.
    • Do network analysis to verify no data or credentials are sent to the server. That is why it is secure.
    • Follow me: @ApexAPI on Twitter
  • YOU CANNOT:
    • Copy all or part of the code to make your own derivated tool; it took me a long time to develop it, I dislike script kiddies stealing the code
    • Sell services based on this tool. It is a free tool for everyone.
X

Donate

Thank you for your support!

I appreciate any financial contribution that will help me to pay for the webhosting and continue to offer new services and innovation.
Choose your currency and then click on the "donate" button

X

Commands

  • /*apex*/ or apex
    Execute anonymous Apex code
  • <html>...
    Run an html page with code leveraging the Ajax Toolkit. Recommended usage:
    <html><head>{!INITAJAXTOOLKIT()}</head>...
  • apexlog [id]
    List logs or display one log
  • Background color
    Change the user interface background color. Useful when you want to differentiate easily a production access from a sandbox access
    Parameter: color - can be a word (color name) or a #xxyyzz value (html rgb value in hexa)
    Example: background orange
  • Cls
    Clear the screen
  • count SObjectAPIName
    High speed count of records in the object displaying same value as in Storage Usage page
  • desc [SObjectName]
    List the attributes of all available objects or detailed description for one object
  • erd [withpackage]
    Display the Entity Relationship Diagram
  • eventlog [Id]
    List available eventlogfiles or display one. You can drill down from the list too.
  • [cache] flush
    Empty the internal cache
  • explain [select.... | ReportId | ListViewId]
    get feedback on Query Performance: explain plan without runing the query
  • find ...
    run a SOSL query
  • limits
    Dump the limit usage for your org, with remaining values and graph
  • password userId
    Identify if the password is expired for the user
  • resetpassword userId
    Define a new random password for the user, display the value and send an e-mail to the user with a link to finish the reset process
  • Select ...
    run a SOQL query
  • Selectool ...
    run a query with the tooling API
  • Services [service]
    Dump URL access to REST API endpoints.
    Parameter: service - optional, to access a deeper endpoint
    Example: services - will dump available service endpoints
    Example: services composite - will dump composite API endpoints
    Example: services composite/tree - to dump more info on the composite tree api
    Example: services theme - will list colors and icons for each object
  • sessions
    Display info on users with active sessions
  • setpassword userId NewPassword
    Set the password value for that user
  • status [POD]
    Display the availability of all or the defined pod.
    Example: status EU6
X

Listing Setup

Configure your listing

X

Loading some code...

Select the listing