Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 01-02-2023, 05:05 PM
Milqn Vuk Milqn Vuk is offline Word macro api call Windows 10 Word macro api call Office 2016
Novice
Word macro api call
 
Join Date: Jan 2023
Posts: 13
Milqn Vuk is on a distinguished road
Default Word macro api call

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
I get the following error: "Compile error" with explanation "Invalid use of new keyword"
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
Reply With Quote
 

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 macro api call Word 2013: Hotkey to call a macro arjfca Word 2 12-04-2014 12:53 AM
Word macro api call Call Macro from Input Box String Paulsh Word VBA 1 11-01-2011 03:15 AM
Word macro api call How do I call/execute an Excel macro from Access 2003 KramerJ Excel 2 05-11-2009 11:33 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 06:14 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft