Support Topics Documentation Slack YouTube Blog

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

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’

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.

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.

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

Thanks!

Hello, @William_Lee.

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

Regards, Nikita.

1 Like

Hi @William_Lee ,

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

Regards,
Mark

1 Like

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.