About vamshi9666

vamshi9666 · ‎08-03-2021

I am trying to create / edit a occasion with new times. New times can be past one. here is the example request: fetch("/api/2.0/messages/<message-id>", { method: "PUT", headers: { "Content-Type":"application/json" }, body: JSON.stringify({ type:"message", subject:" test updating message", occasion_data: { "start_time":moment().sub(1,"hour").toISOString() } }) }).then(r => r.json()).then(console.log).catch(console.log) Same applied for post request while creating.

vamshi9666 · ‎12-30-2020

i am fetching occasion_data via v2 json query and result is a list of object which looks something like this. ``` { "type": "message", "id": "<messageid>", "occasion_data": { "type": "occasion_data", "rsvp": { "query": "SELECT * FROM rsvps WHERE message.id = '<msgid>'" } ``` here i want to fetch rsvps list too using sub-queries. when i tried in this way. it didn't work. ``` { "messages": { "fields": [ "id", "occasion_data.rsvp" ], "constraints": [ { "occasion_data.end_time": { ">=": 1 } } ], "subQueries": { "occasion_data.rsvp": { "fields": [] } } } } ``` i believe the reason is because rsvp is a field in occasion_data which is field in message itself. pleas let me know if any doing wrong or a workaround.

Online Status	Offline
Date Last Visited	14 hours ago

Unable to create message (occasions) with past time in start_time

nested subquery with v2 json query