cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Solarioc Helper I
Helper I

Getting a 502 web server error & JSON

Hello working on a vacation app. I came into this webserver error as well as a JSON error. 

 

Attatched is the server error. Data seems to flow just fine, but throws this error. Attatched the function it is trying to use

 

Error Message: 


 
An error occurred on the server. Server Response: Not a valid connector response. returning message as is: { "error": { "code": 502, "source": "msmanaged-na.azure-apim.net", "clientRequestId": "59ed4b56-1a9f-4327-8257-5935babf4ba5", "message": "The response is not in a JSON format.", "innerError": "\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n
Server Error
\r\n
\r\n
\r\n 502 - Web server received an invalid respon...

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Solarioc Helper I
Helper I

Re: Getting a 502 web server error & JSON

Still getting the error. Tech above reached out and has said that it is working by design SQL cannot use those predicts. 

 

 

Our product team has informed us that this issue is by design and documented in the below link:

 

https://docs.microsoft.com/en-us/connectors/sql/

The following data types cannot be used as query option predicates:

  • date
  • datetime
  • datetime2
  • smalldatetime

 

View solution in original post

3 REPLIES 3
Community Support
Community Support

Re: Getting a 502 web server error & JSON

Hi @Solarioc ,

Could you please share a bit more about your data source used within your app? Is it a SQL Table?

 

Based on the error message that you mentioned, it seems to tell that there is something wrong with the SQL Table connection added within your app.

 

The user @hshah has faced same issue with you, please check my response within the following thread:

https://powerusers.microsoft.com/t5/Common-Data-Service-for-Apps/Powerapp-connected-to-database-with...

 

If the issue still exists, please conside submit an assisted support ticket through the following link:

https://powerapps.microsoft.com/en-us/support/pro

 

Best regards,

Community Support Team _ Kris Dai
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
TopShelf-MSFT Community Champion
Community Champion

Re: Getting a 502 web server error & JSON

Hi @Solarioc are you still receiving this error? Was the above reply helpful? 

 

@TopShelf-MSFT 

Solarioc Helper I
Helper I

Re: Getting a 502 web server error & JSON

Still getting the error. Tech above reached out and has said that it is working by design SQL cannot use those predicts. 

 

 

Our product team has informed us that this issue is by design and documented in the below link:

 

https://docs.microsoft.com/en-us/connectors/sql/

The following data types cannot be used as query option predicates:

  • date
  • datetime
  • datetime2
  • smalldatetime

 

View solution in original post

Helpful resources

Announcements
MBAS Gallery 2020

MBAS Gallery 2020

Watch Microsoft Business Applications Summit sessions on-demand.

firstImage

New Ranks and Rank Icons released on April 21!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power Apps Community!

Power Platform 2020 release wave 1 plan

Power Platform 2020 release wave 1 plan

Features releasing from April 2020 through September 2020

Top Solution Authors
Top Kudoed Authors
Users online (5,839)