Hi,
I have some sample JSON from a 3rd party system that i am using to test a POST into a view so that we can accept information from their systems automatically.
(https://c3abv412.caspio.com/rest/swagger#/Views/ViewsV2_PostRecords)
SAMPLE JSON
{
"Booking": {
"TransactionID": "324065",
"ModifyUserID": "",
"SiteItemID": "1074272",
"ReferrerID1": "book.test.co.uk",
"ReferrerID2": "",
"SiteItemName": "test Cruise",
"SystemTimeZone": "",
"DisplayTimeZone": "",
"BookingMode": "B",
"Online": "true",
"ExternalIP": "195.01.01.01",
"Application": "B2B",
"Affiliate": {
"ID": "1074272",
"ExternalReference1": "BHXPV33",
"ExternalReference2": "",
"sid1": "book.test.co.uk",
"sid2": "",
"sid3": ""}
}
}
I have created 2 tables, 1st "Booking" and 2nd "Affiliate" and have replicated the parameters included in the JSON above - and added both to a view.
However, when testing i get a response of :
{
"Code": "ColumnNotFound",
"Message": "Cannot perform operation because the following field(s) do not exist: 'Booking'",
"Resource": "https://c3abv412.caspio.com/rest/v2/views/Odysseus/records?response=ok",
"RequestId": "9CD844C3-B3F8-4D45-981B-E2979811E74F"
}
Why is it expecting a "Booking" column with the JSON being formatted this way? It seems to be valid JSON.
Can anyone help me?
Thanks
