How do I convert JsonPath syntax to Backendless Json Query syntax?

REST
1

Hi I have the following JsonPath where I’m able to pull the ‘contact_info’ value which is ‘william@nwis.net’ where ‘contact_type’ = ‘email’

2a
2a1862×1000 82.6 KB

As you can see the full JsonPath Syntax is:

$.contacts[?(@.contact_type==‘email’)].contact_info

However the following specific condition:
[?(@.contact_type==‘email’)]

Isn’t recognized by Backendless in the Column/Properties parameter as you can see below.

2c
2c2020×692 69.1 KB

However when I just use the ’ [*] ’ parameter I get a valid response but I only want to show the email value and not the tel values.

2b
2b1674×881 70.9 KB

How do I properly convert this Json Condition statement for Backendless?

Thanks!

2

Hello, @William_Lee.

I created a ticket(BKNDLSS-25912) to investigate your question.

Regards, Nikita.

1 Like
3

Hi @William_Lee ,

I apologize, we currently do not support that variation of the JSON Path definition.

Regards,
Mark

1 Like
4

That would be cool if or when it happens…
I’m really getting into JsonPath because of Backendless. My mind is a little blown by the possibilities.