Forum Discussion

bvasudevan's avatar
bvasudevan
Contributor
5 years ago

V2 api for PayPal community doesn't return any search result

Two weeks before when I executed below V2 query it resulted in 20 rows but when I executed the same query last week it gave only two rows for the same query and now it's giving zero results. Can you ...
  • Parshant's avatar
    Parshant
    5 years ago

    bvasudevan,

    After looking at your API request, I have made changes to API which was causing issue in results.

    https://www.paypal-community.com/ppl/api/2.0/search?q=SELECT id,topic.subject,body,topic.body,view_href, topic.view_href FROM messages WHERE category.id = 'EN' AND subject MATCHES '\Payment issues\' AND is_solution=true ORDER BY kudos.sum(weight) DESC LIMIT 20

     

    One issue was of double quotes at subject MATCHES '\"Payment issues\"' and other one is at DESCLIMIT 20

    Check the above listed API in your browser. Its working fine for me now.

Parshant's avatar
Parshant
Boss
5 years ago

bvasudevan,

After looking at your API request, I have made changes to API which was causing issue in results.

https://www.paypal-community.com/ppl/api/2.0/search?q=SELECT id,topic.subject,body,topic.body,view_href, topic.view_href FROM messages WHERE category.id = 'EN' AND subject MATCHES '\Payment issues\' AND is_solution=true ORDER BY kudos.sum(weight) DESC LIMIT 20

 

One issue was of double quotes at subject MATCHES '\"Payment issues\"' and other one is at DESCLIMIT 20

Check the above listed API in your browser. Its working fine for me now.

  • bvasudevan's avatar
    bvasudevan
    Contributor
    5 years ago

    Thanks for your quick response!!! It works!!!