How to post a JSON file - and pick up via a URL in a Fetch xc column?

hi hi - I am trying to see if I can use a JSON plus fetch column to get values faster to the screen in Glide.

However I do not know how to get a URL for the HTTP POST thing…. or if there is another way of doing it, etc. I think what I want to do is:

  • use an integromat scenario behind the scenes to create a JSON file (done) and then push it to a URL where it could be picked up (value would be something like agent ID + Testflow ID)
  • then use the Fetch xc column to pick up this JSON file when it exists
  • and then use a visibility condition to display a button when there is data in the JSON file
  • and pick up the values to do things with it (specifically, it would give the right agent an ID string - and when they click on the button, it writes that string to the User Profile sheet… and then magic happens).

Any help would be appreciated! Thanks!