Apex Code Development You need to sign in to do that
Don't have an account?
Fenil 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.
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.
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. Let us know if it helps.
All Answers
Could you paste your SOQL query here ?
Filter SOQl by by OwnerId = UserInfo.getUsetId().
Let us know if it helps.
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.
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. Let us know if it helps.