json noob - ELI5

[geezfools]

I've looked at the wiki, I've done some searches elsewhere and this stuff just eludes the heck out of me.

I'm attempting to monitor this JSON page for when new products are added: https://cdn5.editmysite.com/app/store/api/v28/editor/users/144991355/sites/854616809831818796/products?page=1&per_page=30&sort_by=category_order&sort_order=asc&categories[]=11eeee6e456d9a929f7d1e1ffebba068

The site itself is at https://shop.thepunkrockmuseum.com/shop/vinyl-lps/6?page=1&limit=30&sort_by=category_order&sort_order=asc

Can anyone help me so I'm monitoring the "name" only. When I run this through distill, it gives me back this, ."data"[]?."name"
But nothing I do will get CD to recognize that. I tried stuff like json:$.data, etc. I know, I'm a complete noob and just trying to help me and a few friends track some sites to buy vinyl, lol

[VyvaHart]

Hey @geezfools

I can show you the solution using Python script:

import json

# Path to your JSON file
filename = "./test.json"

# Open the file and read its contents
with open(filename, "r") as f:
  data = json.load(f)

# Extract all "name" values
names = [product["name"] for product in data["data"]]

# Print the names
print(names)

Output:
['Vinyl: Bottles To The Ground Comp', 'Slipmat: Lo-Fi Club', 'Slipmat: Vic', 'Slipmat: Chip Logo', 'Vinyl: Glen Matlock - Consequences Coming', 'Vinyl: The Offspring - Smash', 'Vinyl: Joe Strummer - Assembly', 'NOFX - Clay Pigeon LP']

Good Luck!