function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
Fenil Suthar 007Fenil Suthar 007 

Rest API - SOQL Query : Want to get Only Current user's Record

Rest API - SOQL Query :
When I Query i am able to get all user's record instead of mine only. Is there any way to filter for get records of current user only.
Best Answer chosen by Fenil Suthar 007
Ashish_Sharma_DEVSFDCAshish_Sharma_DEVSFDC
Hi,

While doing authentication with salesforce ,you would be getting user details in response.
"id":"https://login.salesforce.com/id/00D50000000IZ3ZEAW/00550000001fg5OAAQ", "asserted_user":true, "user_id":"00550000001fg5OAAQ", "organization_id":"00D50000000IZ3ZEAW", "username":"user@example.com", "nick_name":"user1.2950476911907334E12", "display_name":"Sample User", "email":"user@example.com", "status":{ "created_date":"2010-11-08T20:55:33.000+0000", "body":"Working on OAuth 2.0 article" }, "photos":{ "picture":"https://c.na1.content.force.com/profilephoto/005/F", "thumbnail":"https://c.na1.content.force.com/profilephoto/005/T" }, "urls":{ "enterprise":"https://na1.salesforce.com/services/Soap/c/{version}/00D50000000IZ3Z", "metadata":"https://na1.salesforce.com/services/Soap/m/{version}/00D50000000IZ3Z", "partner":"https://na1.salesforce.com/services/Soap/u/{version}/00D50000000IZ3Z", "rest":"https://na1.salesforce.com/services/data/v{version}/", "sobjects":"https://na1.salesforce.com/services/data/v{version}/sobjects/", "search":"https://na1.salesforce.com/services/data/v{version}/search/", "query":"https://na1.salesforce.com/services/data/v{version}/query/", "recent":"https://na1.salesforce.com/services/data/v{version}/recent/", "profile":"https://na1.salesforce.com/00550000001fg5OAAQ" }, "active":true, "user_type":"STANDARD", "language":"en_US", "locale":"en_US", "utcOffset":-28800000, "last_modified_date":"2011-01-14T23:28:01.000+0000"


Use "user_id":"00550000001fg5OAAQ", userId in SOQL as below.
/services/data/v29.0/query?q=SELECT+Name+from+Account+where+OwnerId=+'00590000001xyr5'
Let us know if it helps.

All Answers

Ashish_Sharma_DEVSFDCAshish_Sharma_DEVSFDC
Hi Fenil Suthar 007,

Could you paste your SOQL query here ?
Filter SOQl by by OwnerId = UserInfo.getUsetId().

Let us know if it helps.
 
Fenil Suthar 007Fenil Suthar 007
Query : Select ID,Name From Opportunity
Visual Froce or Apex is supprot "UserInfo.getUsetId()". Direct SOQL Query call is not support.
I m sending Query to Sales force via rest api.

 
Ashish_Sharma_DEVSFDCAshish_Sharma_DEVSFDC
Hi,

While doing authentication with salesforce ,you would be getting user details in response.
"id":"https://login.salesforce.com/id/00D50000000IZ3ZEAW/00550000001fg5OAAQ", "asserted_user":true, "user_id":"00550000001fg5OAAQ", "organization_id":"00D50000000IZ3ZEAW", "username":"user@example.com", "nick_name":"user1.2950476911907334E12", "display_name":"Sample User", "email":"user@example.com", "status":{ "created_date":"2010-11-08T20:55:33.000+0000", "body":"Working on OAuth 2.0 article" }, "photos":{ "picture":"https://c.na1.content.force.com/profilephoto/005/F", "thumbnail":"https://c.na1.content.force.com/profilephoto/005/T" }, "urls":{ "enterprise":"https://na1.salesforce.com/services/Soap/c/{version}/00D50000000IZ3Z", "metadata":"https://na1.salesforce.com/services/Soap/m/{version}/00D50000000IZ3Z", "partner":"https://na1.salesforce.com/services/Soap/u/{version}/00D50000000IZ3Z", "rest":"https://na1.salesforce.com/services/data/v{version}/", "sobjects":"https://na1.salesforce.com/services/data/v{version}/sobjects/", "search":"https://na1.salesforce.com/services/data/v{version}/search/", "query":"https://na1.salesforce.com/services/data/v{version}/query/", "recent":"https://na1.salesforce.com/services/data/v{version}/recent/", "profile":"https://na1.salesforce.com/00550000001fg5OAAQ" }, "active":true, "user_type":"STANDARD", "language":"en_US", "locale":"en_US", "utcOffset":-28800000, "last_modified_date":"2011-01-14T23:28:01.000+0000"


Use "user_id":"00550000001fg5OAAQ", userId in SOQL as below.
/services/data/v29.0/query?q=SELECT+Name+from+Account+where+OwnerId=+'00590000001xyr5'
Let us know if it helps.
This was selected as the best answer