![]() |
|
#1
|
|||
|
|||
|
Hello,
I want to connect with an outside API service. I try to make an API cole with the following code below: Code:
Function GT(prompt As String) As String
' I Replace MY_API_KEY with my actual API key
Dim apiKey As String: apiKey = "API_KEY"
Dim apiEndpoint As String: apiEndpoint = "https://api.url.com/v1/"
Dim params As String: params = "prompt=" & prompt & "&max_tokens=2048&model=text-davinci-002&stop=.!?"
Dim apiCall As String: apiCall = apiEndpoint & "?" & params
Dim xmlHttp As Object: Set xmlHttp = CreateObject("MSXML2.XMLHTTP")
xmlHttp.Open "POST", apiCall, False
xmlHttp.setRequestHeader "Content-Type", "application/x-www-form-urlencoded"
xmlHttp.setRequestHeader "Authorization", "Bearer " & apiKey
xmlHttp.send
Dim response As String: response = xmlHttp.rText
Dim responseObject As Object: Set responseObject = JsonConverter.ParseJson(response)
Dim generatedText As String: generatedText = responseObject("data")(0)("text")
GT = generatedText
End Function
Debuging: Set responseObject = JsonConverter.ParseJson(response) The error "Set responseObject = JsonConverter.ParseJson(response)" typically indicates that the JsonConverter object or the ParseJson method is not recognized but I think that my API call is not right since I didn't manage to make any successfull API requests. I see this on API endpoint usage to which I have access. Also, I have added these libraries and references in my project:JSONConverter, Microsoft Scripting Runtime library and Microsoft XML, v6.0 library. Could anyone give me any advice how to properly call an API? Would be much appropriated! Thanks Last edited by macropod; 01-09-2023 at 04:00 PM. Reason: Added code tags |
| Tags |
| api, office 2016, vba word |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Is it possible to call a common vba macro on a commandbutton ? | josh2008 | Word VBA | 2 | 02-08-2019 02:02 AM |
| Find word then call signature macro | Dave T | Word VBA | 4 | 03-28-2016 11:18 PM |
Word 2013: Hotkey to call a macro
|
arjfca | Word | 2 | 12-04-2014 12:53 AM |
Call Macro from Input Box String
|
Paulsh | Word VBA | 1 | 11-01-2011 03:15 AM |
How do I call/execute an Excel macro from Access 2003
|
KramerJ | Excel | 2 | 05-11-2009 11:33 AM |