Rather than ChatGPT, fund your API account with credits, and then use the model GPT-4.1 to write your code.
https://platform.openai.com/playground/prompts?models=gpt-4.1
You might start with docs->quickstart on that page to see if using the API is completely out of your wheelhouse before making a purchase to fund the API calls.
Here’s Python that serves as a verbose example of what calling the RESTful API looks like, and parsing out the received response. You can have the AI follow the patterns there, but for the destination language, and simply to construct the single API function needed as input/output.
“Key” to this is keeping your API key secure. If it did work, putting your secrets equivalent to a bank password into a spreadsheet is NOT a good idea.