{ Community }
  • Academy
  • Docs
  • Developers
  • Resources
    • Community Articles
    • Apigee on GitHub
    • Code Samples
    • Videos & eBooks
    • Accelerator Methodology
  • Support
  • Ask a Question
  • Spaces
    • Product Announcements
    • General
    • Edge/API Management
    • Developer Portal (Drupal-based)
    • Developer Portal (Integrated)
    • API Design
    • APIM on Istio
    • Extensions
    • Business of APIs
    • Academy/Certification
    • Analytics
    • Events
    • Hybrid
    • Integration (AWS, PCF, Etc.)
    • Microgateway
    • Monetization
    • Private Cloud Deployment
    • Insights
    • IoT Apigee Link
    • BaaS/Usergrid
    • BaaS Transition/Migration
    • Apigee-127
    • New Customers
    • Topics
    • Questions
    • Articles
    • Ideas
    • Leaderboard
    • Badges
  • Log in
  • Sign up

Get answers, ideas, and support from the Apigee Community

  • Home /
  • Edge/API Management /
avatar image
1
Question by manikanta ponneri · Aug 08 at 06:02 AM · 48 Views apigee edge

Like Operator getting failed in BROWSERS while in POSTMAN iam able to retrieve expected data

@Dino-at-Google

@Dino @Anil Sagar @ Google @Siddharth Barahalikar

I was working on getting stats data using Management APIS

Call made using POSTMAN:

https://{host}/v1/organizations/{abc}/environments/{xyz}/stats/apiproxy?select=sum(message_count)&timeRange=01/16/2019%2000:00~2/01/2019%2000:00&timeUnit=month&filter=(apiproxy%20like%20'abc%')&limit=14400

Got the response which i expected

Call made using BROWSERS:

https://{host}/v1/organizations/{abc}/environments/{xyz}/stats/apiproxy?select=sum(message_count)&timeRange=01/16/2019%2000:00~2/01/2019%2000:00&timeUnit=month&filter=(apiproxy%20like%20'abc%')&limit=14400

500 internal server...i analyzed a lot and i finally found fault with using like Operator

Would anyone please help me with this?

Thanks in advance

Comment
Add comment
10 |5000 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by Apigeeks only
  • Viewable by the original poster
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users

Close

2 Answers

  • Sort: 
avatar image
1
Best Answer

Answer by Nicolas TISSERAND · Sep 02 at 09:08 AM

Hi @manikanta ponneri

I think that the last percent char '%' should be url-encoded in your like clause. If not, this could be the reason why you get a 500 error.

Did you try something like this :

https://{host}/v1/organizations/{abc}/environments/{xyz}/stats/apiproxy?select=sum(message_count)&timeRange=01/16/2019%2000:00~2/01/2019%2000:00&timeUnit=month&filter=(apiproxy%20like%20'abc%25')&limit=14400

(but it doesn't explain why it works with Postman)

Comment
Add comment Show 3 · Link
10 |5000 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by Apigeeks only
  • Viewable by the original poster
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users
avatar image manikanta ponneri · Oct 09 at 11:40 AM 0
Link

Thanks @Nicolas TISSERAND

I ran the script again and it gave me the result

earlier case and now also:

  • i got this error Server returned HTTP response code: 500 for URLwhen i used filter=(apiproxy%20like%20'abc%')&limit=14400

but

  • when i used this filter=(apiproxy%20like%20'abc%25')&limit=14400 i got the expected result.

Thank you very much....!!

capture.jpg (29.2 kB)
avatar image Nicolas TISSERAND manikanta ponneri · Oct 09 at 09:52 PM 1
Link

Hi @manikanta ponneri Glad to hear that.If you don't mind, please vote for my answer in order to mark this topic as resolved. Or @Dino-at-Google could do it ?

avatar image Dino-at-Google ♦♦ Nicolas TISSERAND   · Oct 10 at 12:12 AM 0
Link

Done.......

avatar image
0

Answer by Siddharth Barahalikar   · Aug 08 at 08:57 AM

How are you adding/sending the Authorization header from Browser?

Even without the header you should be getting 401.

Is this a OPDK instance?

Comment
Add comment Show 1 · Link
10 |5000 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by Apigeeks only
  • Viewable by the original poster
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users
avatar image manikanta ponneri · Oct 09 at 11:15 AM 0
Link

Thanks for the response @Siddharth Barahalikar

Call made using BROWSERS:

https://{host}/v1/organizations/{abc}/environments/{xyz}/stats/apiproxy?select=sum(message_count)&timeRange=01/16/2019%2000:00~2/01/2019%2000:00&timeUnit=month&filter=(apiproxy%20like%20'abc%')&limit=14400

Even without the header you should be getting 401.

i agree with this of getting 401 by sending request via browsers. But i have script which uses httpconnectionurl library where i'm providing credentials then i don't get any authorization error.

But i'm wondering with response(500 internal server...) i got using % operator when running in script using IntelliJ tool

Follow this Question

Answers Answers and Comments

129 People are following this question.

avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image

Related Questions

Policy Guidelines for specific use cases 1 Answer

Under what circumstance(s) is the following error message thrown in the Message processor logs : "failed to load http properties". Is this indicative of a class-loading issue or something else ? 2 Answers

What is the @IOIntensive thread pool size ? 2 Answers

APIGEE CONSOLE and TARGET SERVERS 1 Answer

Anyone using Apigee Edge to proxy AWS Services (EC2 / Lambda / S3 ) ? 1 Answer

  • Products
    • Edge - APIs
    • Insights - Big Data
    • Plans
  • Developers
    • Overview
    • Documentation
  • Resources
    • Overview
    • Blog
    • Apigee Institute
    • Academy
    • Documentation
  • Company
    • Overview
    • Press
    • Customers
    • Partners
    • Team
    • Events
    • Careers
    • Contact Us
  • Support
    • Support Overview
    • Documentation
    • Status
    • Edge Support Portal
    • Privacy Policy
    • Terms & Conditions
© 2019 Apigee Corp. All rights reserved. - Apigee Community Terms of Use - Powered by AnswerHub
  • Anonymous
  • Sign in
  • Create
  • Ask a question
  • Create an article
  • Post an idea
  • Spaces
  • Product Announcements
  • General
  • Edge/API Management
  • Developer Portal (Drupal-based)
  • Developer Portal (Integrated)
  • API Design
  • APIM on Istio
  • Extensions
  • Business of APIs
  • Academy/Certification
  • Analytics
  • Events
  • Hybrid
  • Integration (AWS, PCF, Etc.)
  • Microgateway
  • Monetization
  • Private Cloud Deployment
  • Insights
  • IoT Apigee Link
  • BaaS/Usergrid
  • BaaS Transition/Migration
  • Apigee-127
  • New Customers
  • Explore
  • Topics
  • Questions
  • Articles
  • Ideas
  • Members
  • Badges