yes, that is what I have been missing. I was reading the docs on Upsert Block and I see now that in passing it mentions,
Execution of an upsert block also returns the response of the query executed on the state of the database before mutation was executed . To get the latest result, we should commit the mutation and execute another query.
I did not understand that clearly enough that I had to do that before the changes were committed, I understood it to mean that in order to get the data after the upsert I would need to run a separate query.
Looking back in the docs at Mutations using cURL I see:
To commit the mutation, pass the parameter
commitNow=true
in the URL.
A link to committing mutations should probably be on the Upsert Block doc page, now that it is a separate page by itself (I think it used to be one big doc page for Mutations). Maybe even a page dedicated to “Committing Mutations” inside of the Mutation docs that can then be linked to from anywhere discussing the need to commit before changes become “live”