Maya 0 Posted July 5, 2018 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? Share this post Link to post Share on other sites
Tom. 612 Posted July 5, 2018 This is probably your best and easiest option - https://developers.google.com/sheets/api/reference/rest/ 1 Share this post Link to post Share on other sites
Maya 0 Posted July 5, 2018 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. Share this post Link to post Share on other sites
adrian 12,061 Posted July 5, 2018 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. 1 Share this post Link to post Share on other sites