webhelpers | helper functions to make writing web applications | Runtime Evironment library

I'm trying to use a search bar component to dynamically filter the content of a table that's being populated by API requests, however when I use this implementation the component re-renders infinitely and repeatedly sends the same API requests. The useEffect() Hook:

I am trying to get data from Yahoo Finance on Excel on Mac.

As far as I know, the usual approach to get web data on Mac is WebQuery. However, sometimes it works without issues, sometimes throws an error 1004 for the same set of tickers it worked before without issue. Text of the error: "Microsoft Excel cannot access the file %link%. There are several possible reasons:"

I have no clue why does that happen. The only suggestion is because the URL does not contain a cookie / crumb Yahoo needs.

For testing purposes, I used WinHttpRequest on Windows. It works - Excel successfully gets the data. There's an alternative on Mac - Tim Hall's WebHelpers. I was able to get the cookie and the crumb on Mac with this great set of tools. But when I try downloading the CSV from Yahoo the response.Content has this string: {"finance":{"result":null,"error":{"code":"Not Acceptable","description":"HTTP 406 Not Acceptable"}}}.

Generally, I have several questions:

1. Is there a way to add a cookie to the WebQuery approach? Still, I am not sure if that works and helps to evade the error.
2. Why does Response return Error 406? Particularly this code snippet: