Hi,

I am keep on trying to fix this error '500' when consume REST API from OutSystem. It's working in OutSystem test and postman but its not working when I run this app on browser.

Can anyone please suggest me how to fix this issue or I am doing anything wrong like apply filter in URL. I have attached the image from OutSystem test which is working.

Thanks

 

Hi Sanjay,

Look this document about parameter in URL REST

https://success.outsystems.com/Documentation/11/Extensibility_and_Integration/REST/Expose_REST_APIs/Customize_REST_URLs 


Corret format URL:

..items?IncludeA={IncludeA}&IncludeB={IncludeB}


Regards.

Agno Silveira wrote:

Hi Sanjay,

Look this document about parameter in URL REST

https://success.outsystems.com/Documentation/11/Extensibility_and_Integration/REST/Expose_REST_APIs/Customize_REST_URLs 


Corret format URL:

..items?IncludeA={IncludeA}&IncludeB={IncludeB}


Regards.

 

 Hi Agno,

Thanks for replying to my question. I have tried the above URL format but its still giving me the same error '500' and in OutSystem test response, it shows nothing when I tried this format.

Can you please tell me how can I check the error message, I have tried to check the error message from service center but it wasn't helpful.

Sanjay kumar wrote:

Agno Silveira wrote:

Hi Sanjay,

Look this document about parameter in URL REST

https://success.outsystems.com/Documentation/11/Extensibility_and_Integration/REST/Expose_REST_APIs/Customize_REST_URLs 


Corret format URL:

..items?IncludeA={IncludeA}&IncludeB={IncludeB}


Regards.

 

 Hi Agno,

Thanks for replying to my question. I have tried the above URL format but its still giving me the same error '500' and in OutSystem test response, it shows nothing when I tried this format.

Can you please tell me how can I check the error message, I have tried to check the error message from service center but it wasn't helpful.


 Try check in service center, Monitoring > Integrations, to see the integration errors.


I had a question, are you using SAP integration?

Regards.



 

Agno Silveira wrote:

Sanjay kumar wrote:

Agno Silveira wrote:

Hi Sanjay,

Look this document about parameter in URL REST

https://success.outsystems.com/Documentation/11/Extensibility_and_Integration/REST/Expose_REST_APIs/Customize_REST_URLs 


Corret format URL:

..items?IncludeA={IncludeA}&IncludeB={IncludeB}


Regards.

 

 Hi Agno,

Thanks for replying to my question. I have tried the above URL format but its still giving me the same error '500' and in OutSystem test response, it shows nothing when I tried this format.

Can you please tell me how can I check the error message, I have tried to check the error message from service center but it wasn't helpful.


 Try check in service center, Monitoring > Integrations, to see the integration errors.


I had a question, are you using SAP integration?

Regards.



 

 

 I am using REST integration, should I use SAP integration for odata api call?

And I already check the error message from Integration, the error message is '500' and the in stack (HeContext heContext, ICc{url}Callbacks _callbacks, String inParamAuthorization, String inParamincludeVLSlink, String inParamincludeSurveys, STGetUserTodoLearningItemsResponseStructure& outParamResponse).

I am not understanding the error from the stack message.

Sanjay kumar wrote:

Agno Silveira wrote:

Sanjay kumar wrote:

Agno Silveira wrote:

Hi Sanjay,

Look this document about parameter in URL REST

https://success.outsystems.com/Documentation/11/Extensibility_and_Integration/REST/Expose_REST_APIs/Customize_REST_URLs 


Corret format URL:

..items?IncludeA={IncludeA}&IncludeB={IncludeB}


Regards.

 

 Hi Agno,

Thanks for replying to my question. I have tried the above URL format but its still giving me the same error '500' and in OutSystem test response, it shows nothing when I tried this format.

Can you please tell me how can I check the error message, I have tried to check the error message from service center but it wasn't helpful.


 Try check in service center, Monitoring > Integrations, to see the integration errors.


I had a question, are you using SAP integration?

Regards.



 

 

 I am using REST integration, should I use SAP integration for odata api call?

And I already check the error message from Integration, the error message is '500' and the in stack (HeContext heContext, ICc{url}Callbacks _callbacks, String inParamAuthorization, String inParamincludeVLSlink, String inParamincludeSurveys, STGetUserTodoLearningItemsResponseStructure& outParamResponse).

I am not understanding the error from the stack message.

 

You can use both (REST ou SAP integrations), but if you want use REST, look this document, maybe help you:

https://success.outsystems.com/Documentation/How-to_Guides/Integrations/How_to_consume_an_SAP_OData_service_in_OutSystems 

https://www.sapoutsystems.com/SAPOutSystemsHowToConsumeODATA.aspx


Regards.

Agno Silveira wrote:

Sanjay kumar wrote:

Agno Silveira wrote:

Sanjay kumar wrote:

Agno Silveira wrote:

Hi Sanjay,

Look this document about parameter in URL REST

https://success.outsystems.com/Documentation/11/Extensibility_and_Integration/REST/Expose_REST_APIs/Customize_REST_URLs 


Corret format URL:

..items?IncludeA={IncludeA}&IncludeB={IncludeB}


Regards.

 

 Hi Agno,

Thanks for replying to my question. I have tried the above URL format but its still giving me the same error '500' and in OutSystem test response, it shows nothing when I tried this format.

Can you please tell me how can I check the error message, I have tried to check the error message from service center but it wasn't helpful.


 Try check in service center, Monitoring > Integrations, to see the integration errors.


I had a question, are you using SAP integration?

Regards.



 

 

 I am using REST integration, should I use SAP integration for odata api call?

And I already check the error message from Integration, the error message is '500' and the in stack (HeContext heContext, ICc{url}Callbacks _callbacks, String inParamAuthorization, String inParamincludeVLSlink, String inParamincludeSurveys, STGetUserTodoLearningItemsResponseStructure& outParamResponse).

I am not understanding the error from the stack message.

 

You can use both (REST ou SAP integrations), but if you want use REST, look this document, maybe help you:

https://success.outsystems.com/Documentation/How-to_Guides/Integrations/How_to_consume_an_SAP_OData_service_in_OutSystems 

https://www.sapoutsystems.com/SAPOutSystemsHowToConsumeODATA.aspx


Regards.

 Hi Agno,

I already get the details of error by using onAfterResponse and I know what is the problem you can see the screenshot below. The query $filter has the not-allowed value because outsystem automatically add + symbol for space in request URL during the runtime.

I have call this query parameter (link/%24filter=criteria/includeDeeplink eq true) in REST API and then OutSystem convert it like this (criteria/includeDeeplink+eq+true) as you can seen in below pic.

so can you suggest me is there anyway in OutSystem to maintain the space in request URL so that it wont have any + symbol and wont give any error.

Thanks for keep responding to me.


Sanjay kumar wrote:

Agno Silveira wrote:

Sanjay kumar wrote:

Agno Silveira wrote:

Sanjay kumar wrote:

Agno Silveira wrote:

Hi Sanjay,

Look this document about parameter in URL REST

https://success.outsystems.com/Documentation/11/Extensibility_and_Integration/REST/Expose_REST_APIs/Customize_REST_URLs 


Corret format URL:

..items?IncludeA={IncludeA}&IncludeB={IncludeB}


Regards.

 

 Hi Agno,

Thanks for replying to my question. I have tried the above URL format but its still giving me the same error '500' and in OutSystem test response, it shows nothing when I tried this format.

Can you please tell me how can I check the error message, I have tried to check the error message from service center but it wasn't helpful.


 Try check in service center, Monitoring > Integrations, to see the integration errors.


I had a question, are you using SAP integration?

Regards.



 

 

 I am using REST integration, should I use SAP integration for odata api call?

And I already check the error message from Integration, the error message is '500' and the in stack (HeContext heContext, ICc{url}Callbacks _callbacks, String inParamAuthorization, String inParamincludeVLSlink, String inParamincludeSurveys, STGetUserTodoLearningItemsResponseStructure& outParamResponse).

I am not understanding the error from the stack message.

 

You can use both (REST ou SAP integrations), but if you want use REST, look this document, maybe help you:

https://success.outsystems.com/Documentation/How-to_Guides/Integrations/How_to_consume_an_SAP_OData_service_in_OutSystems 

https://www.sapoutsystems.com/SAPOutSystemsHowToConsumeODATA.aspx


Regards.

 Hi Agno,

I already get the details of error by using onAfterResponse and I know what is the problem you can see the screenshot below. The query $filter has the not-allowed value because outsystem automatically add + symbol for space in request URL during the runtime.

I have call this query parameter (link/%24filter=criteria/includeDeeplink eq true) in REST API and then OutSystem convert it like this (criteria/includeDeeplink+eq+true) as you can seen in below pic.

so can you suggest me is there anyway in OutSystem to maintain the space in request URL so that it wont have any + symbol and wont give any error.

Thanks for keep responding to me.


 

Hello,

Did you create this step? (2 Add on "OnBeforeRequest" )



https://success.outsystems.com/Documentation/How-to_Guides/Integrations/How_to_consume_an_SAP_OData_service_in_OutSystems 


It would be good to follow all the steps in this document.


Regards.




 

Agno Silveira wrote:

Sanjay kumar wrote:

Agno Silveira wrote:

Sanjay kumar wrote:

Agno Silveira wrote:

Sanjay kumar wrote:

Agno Silveira wrote:

Hi Sanjay,

Look this document about parameter in URL REST

https://success.outsystems.com/Documentation/11/Extensibility_and_Integration/REST/Expose_REST_APIs/Customize_REST_URLs 


Corret format URL:

..items?IncludeA={IncludeA}&IncludeB={IncludeB}


Regards.

 

 Hi Agno,

Thanks for replying to my question. I have tried the above URL format but its still giving me the same error '500' and in OutSystem test response, it shows nothing when I tried this format.

Can you please tell me how can I check the error message, I have tried to check the error message from service center but it wasn't helpful.


 Try check in service center, Monitoring > Integrations, to see the integration errors.


I had a question, are you using SAP integration?

Regards.



 

 

 I am using REST integration, should I use SAP integration for odata api call?

And I already check the error message from Integration, the error message is '500' and the in stack (HeContext heContext, ICc{url}Callbacks _callbacks, String inParamAuthorization, String inParamincludeVLSlink, String inParamincludeSurveys, STGetUserTodoLearningItemsResponseStructure& outParamResponse).

I am not understanding the error from the stack message.

 

You can use both (REST ou SAP integrations), but if you want use REST, look this document, maybe help you:

https://success.outsystems.com/Documentation/How-to_Guides/Integrations/How_to_consume_an_SAP_OData_service_in_OutSystems 

https://www.sapoutsystems.com/SAPOutSystemsHowToConsumeODATA.aspx


Regards.

 Hi Agno,

I already get the details of error by using onAfterResponse and I know what is the problem you can see the screenshot below. The query $filter has the not-allowed value because outsystem automatically add + symbol for space in request URL during the runtime.

I have call this query parameter (link/%24filter=criteria/includeDeeplink eq true) in REST API and then OutSystem convert it like this (criteria/includeDeeplink+eq+true) as you can seen in below pic.

so can you suggest me is there anyway in OutSystem to maintain the space in request URL so that it wont have any + symbol and wont give any error.

Thanks for keep responding to me.


 

Hello,

Did you create this step? (2 Add on "OnBeforeRequest" )



https://success.outsystems.com/Documentation/How-to_Guides/Integrations/How_to_consume_an_SAP_OData_service_in_OutSystems 


It would be good to follow all the steps in this document.


Regards.




 

 Hi Agno,

Yes. I have used both onAfterRequest and onBeforeReauest as mentioned on document(how to consume SAP odata service).

But this is just for add the $ symbol before the filter query and it’s working for me.

How can we remove the + symbol on request URL so meaning the request URL can have either this %20 or space then I wont get error..

But when I tried to use %20 or space in query parameter then outsystem automatically change it to + symbol during runtime.