Cannot Update Dreamfactory Records

[Deon]

Hi

you most probably gonna say it is outside your scope of support but I beg to differ....

I have a service that updates a dreamfactory table/record. When I perform a test in Appery, it works perfectly and updates the record perfectly. However it does not work when I map the service.
I either get Internal Error 500 or 400

The Request and Body values are correct.

How can I see what is sent to Dreamfactory during the test as I think it not the same that gets sent during production

Why would there be a difference between the test and actual production?

Thx

[Alena Prykhodko]

Hello Deon,

Please show us your service settings, mapping, request and response tabs screen shots.

[Deon]

Hi
I have tried the Delete Service which uses the exact same Query obviously without the body parameters.. This works perfectly. It seems the query is requesting the correct record but there is an issue with the body (Except it working when testing the service)
This is my service settings config

This is my Body In the Request.Settings

This is my Request with Successful Test Results. Data was updated in table.

This is my mapping. There is no response mapping as this is an Update and oes not require a response.

Error

[Deon]

Hi Alena

The isssue is i the mappings. I have deleted all the mappings and only kept Name and Surname. Works perfectly.

I am going to have a look at which mapping is causing the problem and will revert back.

Thank you

[Deon]

The problem was with the birthdate field. The database fieldtype was incorrectly set to datetime instead of date only. It work fine with testing because I only map two fields which did not include that birthdate field.

Moral of the story: Compare Apples with Apples. aaaagh I have wasted days on something that was actually working all the time

Thank you