Querying JSON array values in a mock API not working

My requirement is to have a json array in the dataset. But when I try to write formula on API schema to get the values inside json array using a primary key (like customer_id), I am getting null always

from_dataset(“A 1000 Credit cards”,“creditinfo.name”,cardID:request_params[‘cardid’])

In the above formula creditinfo is a json array and name is one the field inside json array. cardID is what I am using in my API.

Hello, my friend, I am also facing the problem. I was searching for it online and found your post. I thought someone would reply to you here regarding your question answer but still, no one did. Can someone please reply to this question answer? By the way, if anyone here is interested in playing gambling games then you can play those games over here https://zodiac.casinosapproved.info/. It is easy to play games on that website and also you can earn money over there.