You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
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 .
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.
The text was updated successfully, but these errors were encountered:
=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 .
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.
The text was updated successfully, but these errors were encountered: