Skip to main content

Hi,

I created a simple POST REST API in IFS Developer studio for IFS Cloud dev environment. The query which I have used is POST method, which is very simple SQL statement and able to see the data through Oracle SQL developer.

If I call the REST API through Postman, it always throws “Data mapping error due to type mismatch” error. I checked the structure, all the attributes of structure are declared as string and query is also returning everything in string.

Attached the screen shot and errors. if any one has faced these kind of issues, please let me know the solutions.

Projection method

 

Attribute

 

Query output in Oracle SQL Developer

Postman Error

 

Hi @vsraman85 ,

I see your column names in your SQL query doesn’t match the attribute names in the Structure.

I think this is the cause of the error. Let me know if you found any other solution.

 

Thanks,
Rohit

 

Reply


Terms & ConditionsCookie settings