Dynamic filed update in opentext

[Maya]

Hi all, I am new to this forum and I need your support in getting few answers for my queries.

I am working with opentext reddot and in that I need to know the possibilities for the below scenario.

  I have created a page using a template and in that page I need one field alone to be updated dynamically based on the excel file which I have with me . Whatever I have as a value for that particular filed in the excel file it should be updated in Cms.

Is it possible to have any api build to do this funtion. Where we can connect the cms page with that excel file through api? 

[Tom.]

This is probably your best and easiest option - https://developers.google.com/sheets/api/reference/rest/

[Maya]

Thanks for your reply and to be frank I am not a an experienced person in developing and it's really difficult for me to understand the concept here. I wanted to know whether we do this in opentext through api. If we can do then I need to know from scratch what I should do to acheive this... kindly help me in guiding.

[adrian]

PHPSpreadsheet will let you read the file:

https://phpspreadsheet.readthedocs.io/en/develop/topics/reading-files/

Once you have read the cell that you need, you can add that to a PW page field with the PW API.

It's really not that complicated to do, but you might find it a little challenging at first to get your head around things.