Erro to query where string condition

jjunin · February 23, 2021, 1:09pm

Hello,

I have an error in my parse query.

I have a “numberPhone” column of type string but the query does not return the value.

https://mylocalserver.com/parse/classes/numberVerified?where={"numberPhone":"+1-541-754-3010 "}

errorparse

uzaysan · February 23, 2021, 4:17pm

What do you get as response? You should probably pass application id as request header. And there is an empty space after phone number. Can you remove that space and try again?

dplewis · February 23, 2021, 4:18pm

I think you have an extra space at the end your number

jjunin · February 23, 2021, 6:23pm

@uzaysan The query is answered, parse returns me an empty list.

@dplewis There is no empty space, as I certify at the time of inclusion of the record.

parse erro2

uzaysan · February 23, 2021, 6:29pm

Empty space is not in the parse object. İts in the query.

Look closer:
here={"numberPhone":"+1-541-754-3010 "}

there is an empty space between 0 and ". see: 4-3010 "}

jjunin · February 23, 2021, 6:39pm

@uzaysan Oops, I didn’t notice this space, but I corrected it according to the image below and the error persists.

Sorry @dplewis I didn’t understand it the first time. I thought you referred to the record recorded in Parse.

I did some tests removing the special characters and leaving only numbers and it works.

But this way I lose the display format, I did not want to have to make the duplicate record, only numeric and the other with the formatted one.

uzaysan · February 23, 2021, 6:47pm

I think you should convert json to string first. Can you try this:
https://mylocalserver.com/parse/classes/numberVerified?where={\"numberPhone\":\"+1-541-754-3010\"}

jjunin · February 23, 2021, 6:51pm

Error

jjunin · February 24, 2021, 1:34pm

Hello!!

I kept that thought in mind and couldn’t understand it.

I believe this is an error in the query, I did a test, removed the “+” character and it worked successfully.

Can you please test this scenario in your environment? To try to discover this error?

@dplewis and @uzaysan

davimacedo · February 24, 2021, 7:13pm

Since you are passing your where clause in the query string, you need to url encode your data. Seeing your query, + needs to be url encoded, and that’s why it works when you remove it. Replace + to %2B and it should work.

jjunin · February 25, 2021, 1:40pm

Same error, no results

davimacedo · February 25, 2021, 5:32pm

Would you mind to share your current curl command which is causing the error?

jjunin · February 26, 2021, 12:16pm

Yes @davimacedo , sure:

curl -X GET \
  -H "X-Parse-Application-Id: SECRET_TOKEN" \
  -H "X-Parse-Client-Key: SECRET_TOKEN" \
  -H "X-Parse-Session-Token: SECRET_TOKEN" \
  -G \
  --data-urlencode 'where={"number": "%2B1-541-754-3010"}' \
  https://parseapi.back4app.com/classes/numberVerified

davimacedo · February 26, 2021, 6:52pm

In the case of this curl command, --data-urlenconde option already encodes the “+” sign for you so you don’t need to encode yourself. I’ve just tested here, and the following command successfully worked for me:

curl -X GET \
  -H "X-Parse-Application-Id: SECRET_TOKEN" \
  -H "X-Parse-Client-Key: SECRET_TOKEN" \
  -G \
  --data-urlencode 'where={"number": "+1-541-754-3010"}' \
  https://parseapi.back4app.com/classes/numberVerified

jjunin · March 2, 2021, 11:54am

@davimacedo resolved, sorry for the delay in response. Because I was analyzing what was going on. The SDK I use does not do UrlEncode (), I will request a PR for the next version.