CSV => URL?

[magnusmanske]

How can I construct a URL to the move page at http://catalogue-lumiere.com/ from the CSV?
Something like http://catalogue-lumiere.com/ ?

[ms-studio]

Hi Magnus,

Thanks for asking!

One thing you can do is to query via the WordPress REST-API, which will give you the content in JSON.

For example, let's say you need to to get the content about this movie: https://catalogue-lumiere.com/priere-du-muezzin/

The CSV fields are: "197",2,"Prière du muezzin","operator-15","Alexandre Promio", etc...

The first two numbers are identifiers. The first ("Numero-Original") is the number used in the Lumière catalogs from the early 1900s. The second ("Numero-Livre") is the number used by historians Michelle Aubert et Jean-Claude Seguin in their 1996 book.

Here's how you would structure such a query:

• Using "Numero-Original": https://catalogue-lumiere.com/wp-json/wp/v2/posts?filter[meta_key]=Numero-Original&filter[meta_value]=197
• Using "Numero-Livre": https://catalogue-lumiere.com/wp-json/wp/v2/posts?filter[meta_key]=Numero-Livre&filter[meta_value]=2

If you need another type of output, let me know what your use case is, and we can think about other ways of accessing the information.