platform_reservation_number is NULL for reservations made through personal website

When using the API to retrieve bookings, AirBNB and VRBO come in with a correct platform_reservation_number.

But bookings made through my personal website have no reservation number

API query:  https://api.ownerrez.com/v2/bookings?limit=100&include_charges=True&property_ids=xxxxx,yyyyyy,zzzz&from=2024-01-01&to=2024-05-31

Here is a screenshot of the data dumped into Excel

Yes, this is normal.  Bookings booked through your own website don't have a platform reservation number, because they weren't booked on a booking platform (Airbnb, Vrbo, etc.) - they were booked directly on your website.  The relevant number for them is the ORB number that all bookings of every type have, which is in the id column.

I also found a booking with NULL listing_site. When I looked in OR it was a manual quote and manual booking that I had made. Is this also expected?

Tim

Yes, since by definition if you manually entered a booking, we don't really know where it came from.  There has been discussion over the years about adding "manual" as its own listing site entry, but that's never seemed quite satisfactory either.