Get schedule information via REST API.

[matteoking4]

Hi all,

I am searching for a solution to get the schedule entry data from a custom schedule tabl(that extends the cmn_schedule table). 

When I use the table API and do a get request. I receive all the information about that schedule, but nothing related to its entries. If anybody can explain how this works, it would be greatly appreciated.

Thanks,

Mat

[Ankur Bawiskar · Accepted solution]

Hi Mat,

That is because the schedule entries table is different than the cmn_schedule and you are running the table API on cmn_schedule table.

To get the schedule entries use table API for table cmn_schedule_span and pass the schedule sys_id.

Mark Correct if this solves your issue and also hit Like and Helpful if you find my response worthy based on the impact.
Thanks
Ankur

[matteoking4]

Hi Ankur, Thank you! You are right.

If I query the cmn_schedule_span table, I can get all the entry information + the sys_id of the cmn_schedule record. 

[matteoking4]

Hi Ankur, I have one more question :).

You can get the time information from the cmn_schedule_span. It also contains a reference to the schedule located in the cmn_schedule table. 

My question is now if you can get the entry(cmn_schedule_span) from the cmn_schedule table record. So if I query a random table that references the cmn_schedule table, I get the entry values(cmn_schedule_span) from that schedule. Some value like schedule.entry.start_date_time.

Greetings

Mat

[Ankur Bawiskar]

Hi Mat,

Can you explain what you want to ask in detail?

Regards

Ankur