Help with JSON_TABLE

First time trying to do this and I have not found a good guide to explain
how this works.

I am trying to get this working. I am running it in ACS's SQL. It runs and
produces a blank screen. I do not see any errors in the joblog.

select q.*

--into :result

from JSON_TABLE('{ "CustomerAccountNumber": 1000171,

"AuthKey": "fjdsklfjdkslfdj",

"Parts": ["924-125"] }',

'lax $.Parts[*]'

Columns(

"PartNumber" char(20),

"AvailableQuantity" char(20),

"Price" char(20),

"Message1" varchar(1000),

"Message2" varchar(1000)

)) as Q

;



Questions:

How does it know what website to contact?


Is it writing to a file or returning a string?


If we request multiple parts, can I do a select into an array?


TIA, Darryl FReinkel.