API Versions - Fetch
Retrieve REST API versions available in Salesforce, using SQL Server
- See SQLHTTP easy setup for Salesforce
- See API Call documentation for parameter values and other information
- Create the stored procedure documented below
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 |
CREATE PROCEDURE usp_Salesforce_AvailableAPIVersions_Fetch( @Profile nvarchar(100), @Response nvarchar(MAX) OUTPUT, @StatusCode int OUTPUT, @StatusDescription nvarchar(MAX) OUTPUT) AS DECLARE @URL nvarchar(MAX) DECLARE @HTTPSessionID uniqueidentifier DECLARE @BaseURL varchar(100) SET @BaseURL = 'salesforce.com' SET @URL = SQLHTTP.net.AuthParam(@Profile, 'InstanceURL') EXEC SQLHTTP.net.UrlBuilder @URL OUTPUT, @Profile, 'services','data' EXEC SQLHTTP.net.HTTPSession @HTTPSessionID OUTPUT EXEC usp_Salesforce_Auth_Header @Profile, @HTTPSessionID EXEC SQLHTTP.net.HTTPRequest @HttpSessionID, @URL = @URL, @Method = 'GET', @ContentType = 'application/json', @Accept = 'application/json', @StatusCode = @StatusCode OUTPUT, @StatusDescription = @StatusDescription OUTPUT, @Response = @Response OUTPUT GO |
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 |
DECLARE @Response nvarchar(MAX) DECLARE @StatusCode int DECLARE @StatusDescription nvarchar(MAX) DECLARE @Profile nvarchar(100) SET @Profile = 'My Salesforce' --Salesforce Bearer Token is valid for only a few hours EXEC usp_Salesforce_Auth_Refresh @Profile EXEC usp_Salesforce_AvailableAPIVersions_Fetch @Profile = @Profile, @Response = @Response OUTPUT, @StatusCode = @StatusCode OUTPUT, @StatusDescription = @StatusDescription OUTPUT IF @StatusCode >= 400 EXEC SQLHTTP.net.RaiseHttpError @StatusCode, @StatusDescription, @Response ELSE BEGIN DECLARE @X xml SET @X = SQLHTTP.net.Json_To_Xml(@Response, '0') --The XPath syntax below was easily generated by executing the following commands: --EXEC SQLHTTP.net.XQueryHelper @X --and then executing: --EXEC SQLHTTP.net.XQueryHelper @X, 'JsonArray/JsonObject' SELECT T.C.value(N'@version', N'nvarchar(MAX)') AS [version] ,T.C.value(N'@label', N'nvarchar(MAX)') AS [label] ,T.C.value(N'@url', N'nvarchar(MAX)') AS [url] FROM @X.nodes(N'/JsonArray/JsonObject') T(C) ORDER BY [version] DESC END |
|
1 2 3 4 5 6 7 8 |
version label url --------- ----------- --------------------- 40.0 Summer '17 /services/data/v40.0 39.0 Spring '17 /services/data/v39.0 38.0 Winter '17 /services/data/v38.0 37.0 Summer '16 /services/data/v37.0 |
- API Resources – Fetch
- API Versions – Fetch
- Event Monitoring – Fetch
- EventLogFile – Query
- Field Values from an External Object – Fetch
- Objects – Fetch
- Organization Limits – Fetch
- Parameterized Search for a String – Fetch
- Query Performance – Fetch
- Search Result Layout – Fetch
- SObject Fields and Metadata – Fetch
- SObject Metadata – Fetch
- SObject Record – Create
- SObject Record – Delete
- SObject Record – Update
- SObject Record Field Values – Fetch
- User Password – Set
- User Password Expiration- Fetch
IMPORTANT DISCLAIMER
CODE/SQL ON THESE PAGES ARE PROVIDED AS-IS AND ARE AVAILABLE FOR ILLUSTRATIVE PURPOSES ONLY.
USERS ARE REQUIRED TO ABIDE BY THE TERMS AND CONDITIONS FOR USING REFERENCED THIRD PARTY WEBSITES AND/OR APIs FROM THEIR RESPECTIVE WEBSITES. WE DO NOT CONDONE ANY VIOLATION OF THIRD PARTY WEBSITES AND/OR APIs TERMS AND CONDITIONS USING OUR SOFTWARE.
USERS SHALL BE SOLELY RESPONSIBLE AND BE SOLELY LIABLE FOR VIOLATION OF ANY RULES SPECIFIED BY THIRD PARTIES FOR USING THEIR WEBSITES AND/OR APIs, OR INFRINGEMENT OF RIGHTS OF SUCH THIRD PARTIES.