[GNC] Yahoo JSON - throwing unauthorized error

[David Carlson]

This hasn't been repeated for a while, So I will add that the work-around
that Bruce Schuck offered in his email Saturday, May 6 at 2:12 PM Central
time (well, that's where I live) to change

my $YIND_URL_HEAD = '
https://query1.finance.yahoo.com/v7/finance/quote?symbols='; to
my $YIND_URL_HEAD = '
https://query1.finance.yahoo.com/v6/finance/quote?symbols=';

in the correct Yahoo.JSON.pm  file does work.  It is easy to find on a
Linux machine, but you need root privileges to edit it.


On Mon, May 8, 2023 at 2:22 PM David T. via gnucash-user <
gnucash-user at gnucash.org> wrote:

> All good points!
>
> ⁣David T. ​
>
> On May 8, 2023, 7:36 PM, at 7:36 PM, Bruce Schuck <
> bschuck at asgard-systems.com> wrote:
> >On 5/8/23 13:05 +0300, David T. wrote:
> >
> >> It's a wiki, so you could put it in. You'd get to decide where that
> >> would best live, too.
> >
> >Perhaps sometime during the week I'll add something. With the obvious
> >warnings about making backups and the possibility of making a mess for
> >one's self.
> >
> >> FWIW, my method for doing this is to save the file as an SQLite
> >> file, open the result in a DB reader, locate the appropriate table
> >> there, and execute the change globally. Then I reopen the file in
> >> GnuCash and save it back to xml.
> >
> >> It feels easier to me to do it this way and it doesn't take much
> >> time.
> >
> >SQLite queries may be a bit more than some users are willing to try.
> >But
> >I can see where it would be easy for those comfortable with it. Same
> >reason xmlstarlet would be simple for those familiar with it.
> >
> >If I unpacked the .gnucash file to foobar.gnucash, this command would
> >change the quote source globally.
> >
> >xmlstarlet ed --inplace -u
> >'/gnc-v2/gnc:book/gnc:commodity/cmdty:quote_source["yahoo_json"]' -v
> >'alphavantage' foobar.gnucash
> >
> >One can also selectively change the quote source for a specific
> >namespace. This command would change the quote source for just the
> >NASDAQ securities.
> >
> >xmlstarlet ed --inplace -u
>
> >'/gnc-v2/gnc:book/gnc:commodity[cmdty:space="NASDAQ"]/cmdty:quote_source["yahoo_json"]'
> >
> >-v 'alphavantage' foobar.gnucash
> >
> >- Bruce S.
> >_______________________________________________
> >gnucash-user mailing list
> >gnucash-user at gnucash.org
> >To update your subscription preferences or to unsubscribe:
> >https://lists.gnucash.org/mailman/listinfo/gnucash-user
> >-----
> >Please remember to CC this list on all your replies.
> >You can do this by using Reply-To-List or Reply-All.
> _______________________________________________
> gnucash-user mailing list
> gnucash-user at gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -----
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>


-- 
David Carlson