not an issue, just asking for help.

[emealmada]

1. how can i retrieve the value of url from this query: =IMPORTJSONAPI("https://www.balai.cv/wp-json/wp/v2/posts", "$..*", "id,date_gmt,title.rendered,excerpt.rendered,categories,tags,link,yoast_head_json.og_image.url")

using this query $..yoast_head_json.og_image..url in the browser demo i get the desired results . i tried a couple of ways but i can't get the intended results .

2. Additionally, can i get an help when filtering arrays. im the example above. i'm trying to filter all posts by categories , since they are in another array, i cant filter it.
   i tried =IMPORTJSONAPI("https://www.balai.cv/wp-json/wp/v2/posts", "$..[?(@.categories==='6')]*", "id,date_gmt,title.rendered,excerpt.rendered,categories,tags,link,yoast_head_json.og_image.url") ,and a couple variations to no avail.

thanks in advance.