Access to resource is forbidden for open API & web data

Hi stephaniekeen  I have used the query URL you have mention to extract json information. Please use the below code in power query to extract json data. First create a blank query and paste the below code. Tweak fields name accordingly.

let

Source = "https://services1.arcgis.com/ESMARspQHYMw9BZ9/arcgis/rest/services/Online_ONS_Postcode_Directory_Live/FeatureServer/0/query?where=1%3D1&outFields=*&outSR=4326&f=json",

data = Json.Document(Web.Contents(Source)),

features = data[features],

ConvertedtoTable = Table.FromList(
features,
Splitter.SplitByNothing(),
null,
null,
ExtraValues.Error
),

ExpandedColumn1 = Table.ExpandRecordColumn(
ConvertedtoTable, "Column1",
{"attributes", "geometry"},
{"attributes", "geometry"}
),

ExpandedAttributes = Table.ExpandRecordColumn(
ExpandedColumn1,
"attributes",
{"OBJECTID", "PCD", "PCD2", "PCDS", "DOINTR", "DOTERM", "OSCTY", "CED", "OSLAUA", "OSWARD", "USERTYPE",
"OSEAST1M", "OSNRTH1M", "OSGRDIND", "OSHLTHAU", "NHSER", "CTRY", "RGN", "PCON", "TTWA", "PARK", "OA11",
"LSOA11", "MSOA11", "PARISH", "WZ11", "SICBL", "BUA11", "BUASD11", "RU11IND", "OAC11", "LAT", "LONG",
"LEP1", "LEP2", "PFA", "IMD", "CALNCV", "ICB", "ITL", "OA21", "LSOA21", "MSOA21"},

{"OBJECTID", "PCD", "PCD2", "PCDS", "DOINTR", "DOTERM", "OSCTY", "CED", "OSLAUA", "OSWARD", "USERTYPE",
"OSEAST1M", "OSNRTH1M", "OSGRDIND", "OSHLTHAU", "NHSER", "CTRY", "RGN", "PCON", "TTWA", "PARK", "OA11",
"LSOA11", "MSOA11", "PARISH", "WZ11", "SICBL", "BUA11", "BUASD11", "RU11IND", "OAC11", "LAT", "LONG",
"LEP1", "LEP2", "PFA", "IMD", "CALNCV", "ICB", "ITL", "OA21", "LSOA21", "MSOA21"}
),

Expandedgeometry = Table.ExpandRecordColumn(
ExpandedAttributes,
"geometry",
{"x", "y"},
{"x", "y"}
)

in
Expandedgeometry



Hope this helps!!

If this solved your problem, please mark it as a solution.