Chilkat HOME .NET Core C# Android™ AutoIt C C# C++ Chilkat2-Python CkPython Classic ASP DataFlex Delphi ActiveX Delphi DLL Go Java Lianja Mono C# Node.js Objective-C PHP ActiveX PHP Extension Perl PowerBuilder PowerShell PureBasic Ruby SQL Server Swift 2 Swift 3,4,5... Tcl Unicode C Unicode C++ VB.NET VBScript Visual Basic 6.0 Visual FoxPro Xojo Plugin
(SQL Server) Auth0 Server-to-Server Access Token (Client Credentials flow)Demonstrates how to obtain an Auth0 access token using client credentials (client_id and client_secret). This is just a matter of duplicating this CURL command: curl --request POST --url 'https://chilkat.auth0.com/oauth/token' \ --header 'content-type: application/json' \ --data '{"grant_type":"client_credentials","client_id": "xxxx","client_secret": "xxxx","audience": "https://api.example.com/geocoding/v1/"}'
-- Important: See this note about string length limitations for strings returned by sp_OAMethod calls. -- CREATE PROCEDURE ChilkatSample AS BEGIN DECLARE @hr int DECLARE @iTmp0 int -- Important: Do not use nvarchar(max). See the warning about using nvarchar(max). DECLARE @sTmp0 nvarchar(4000) -- This example assumes the Chilkat API to have been previously unlocked. -- See Global Unlock Sample for sample code. -- We want to duplicate this curl command: -- -- curl --request POST -- --url 'https://chilkat.auth0.com/oauth/token' \ -- --header 'content-type: application/json' \ -- --data '{"grant_type":"client_credentials","client_id": "my_client_id","client_secret": "my_client_secret","audience": "https://api.example.com/geocoding/v1/"}' -- Build the JSON body of the request. DECLARE @json int -- Use "Chilkat_9_5_0.JsonObject" for versions of Chilkat < 10.0.0 EXEC @hr = sp_OACreate 'Chilkat.JsonObject', @json OUT IF @hr <> 0 BEGIN PRINT 'Failed to create ActiveX component' RETURN END DECLARE @success int EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'grant_type', 'client_credentials' EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'client_id', 'AUTH0-CLIENT-ID' EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'client_secret', 'AUTH0-CLIENT-SECRET' EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'audience', 'https://api.example.com/geocoding/v1/' -- IMPORTANT: You would use your own url. You would not use "chilkat.auth0.com". -- Instead you would use "your_name.auth0.com" DECLARE @http int -- Use "Chilkat_9_5_0.Http" for versions of Chilkat < 10.0.0 EXEC @hr = sp_OACreate 'Chilkat.Http', @http OUT DECLARE @resp int EXEC sp_OAMethod @http, 'PostJson3', @resp OUT, 'https://chilkat.auth0.com/oauth/token', 'application/json', @json EXEC sp_OAGetProperty @http, 'LastMethodSuccess', @iTmp0 OUT IF @iTmp0 <> 1 BEGIN EXEC sp_OAGetProperty @http, 'LastErrorText', @sTmp0 OUT PRINT @sTmp0 EXEC @hr = sp_OADestroy @json EXEC @hr = sp_OADestroy @http RETURN END -- A 200 response status code indicates success. In the success case, the response body -- contains the JSON access token, such as: -- { -- "access_token": "eyJz93a...k4laUWw", -- "token_type":"Bearer", -- "expires_in":86400 -- } -- EXEC sp_OAGetProperty @resp, 'StatusCode', @iTmp0 OUT PRINT 'response status code = ' + @iTmp0 -- The repsonse is JSON if successful and also JSON for errors. DECLARE @jsonResp int -- Use "Chilkat_9_5_0.JsonObject" for versions of Chilkat < 10.0.0 EXEC @hr = sp_OACreate 'Chilkat.JsonObject', @jsonResp OUT EXEC sp_OASetProperty @jsonResp, 'EmitCompact', 0 EXEC sp_OAGetProperty @resp, 'BodyStr', @sTmp0 OUT EXEC sp_OAMethod @jsonResp, 'Load', @success OUT, @sTmp0 EXEC sp_OAGetProperty @resp, 'StatusCode', @iTmp0 OUT IF @iTmp0 <> 200 BEGIN -- The response body contains error information in JSON format. EXEC sp_OAMethod @jsonResp, 'Emit', @sTmp0 OUT PRINT @sTmp0 EXEC @hr = sp_OADestroy @resp -- An example of an error response: -- { -- "error": "access_denied", -- "error_description": "Client is not authorized to access \"https://api.example.com/geocoding/v1/\". You might probably want to create a \"client-grant\" associated to this API. See: https://auth0.com/docs/api/v2#!/Client_Grants/post_client_grants" -- } EXEC @hr = sp_OADestroy @json EXEC @hr = sp_OADestroy @http EXEC @hr = sp_OADestroy @jsonResp RETURN END PRINT 'Success!' EXEC sp_OAMethod @jsonResp, 'Emit', @sTmp0 OUT PRINT @sTmp0 -- A successful JSON response body looks like this: -- { -- "access_token": "eyJz93a...k4laUWw", -- "token_type":"Bearer", -- "expires_in":86400 -- } EXEC @hr = sp_OADestroy @resp EXEC @hr = sp_OADestroy @json EXEC @hr = sp_OADestroy @http EXEC @hr = sp_OADestroy @jsonResp END GO |
© 2000-2024 Chilkat Software, Inc. All Rights Reserved.