org-ql (https://github.com/alphapapa/org-ql) is also quite good for this kind of thing.

Here is even a database like query to find the heading, and EMAIL property from all the files in a list returned by the function nb-org-files.

(org-ql-query
  :select '(cons (fifth (org-heading-components))
 (org-entry-get (point) "EMAIL"))
  :from (nb-org-files)
  :where '(and (property "EMAIL")))


John

-----------------------------------
Professor John Kitchin 
Doherty Hall A207F
Department of Chemical Engineering
Carnegie Mellon University
Pittsburgh, PA 15213
412-268-7803


On Sun, Feb 23, 2020 at 8:25 AM Vikas Rawal <vikasrawal@gmail.com> wrote:

>
> > I don't know if I have missed something obvious. But I am trying to
> > read all the properties data (key-value pairs) into an R source code
> > block (essentially to gather into a data.frame before further
> > processing).
>
> You might want to look at `org-map-entries'.

Thanks. It seems it will take more lisp than I can handle. But let me try.

I think there is a potential to combine orgmode tags and properties, with a little more lisp may be, along with version control to create small database applications.

It would be good to design something as a proof-of-concept.

Vikas