#1 2017-04-07 02:31:12

cuc1491548801

Automated data exporting using AC API (XML) & Excel

Hi everyone,

I would like to export data from Adobe Connect into Excel using Excel's XML connector (live to URL, not via downloaded file). The data retrieval works very well if you setup the connection in Excel however you cannot refresh the data automatically later given that your session is timed out. On top of that we're using enhanced security so the following applies: http://blogs.adobe.com/connectsupport/using-the-xml-api-with-enhanced-security/

Did you already experience the same situation and did anyone of you already write a script for the session login which you would be willing to share?

Any question please let me know.

Many thanks,
Willy

Jorma_at_CoSo

Re: Automated data exporting using AC API (XML) & Excel

I don't believe you can get live data from an API call with Connect. You would need to set up a script that would query Connect on a regular interval to get updated information.

---

CoSo Cloud
Adobe Certified Instructor

willyflor

Re: Automated data exporting using AC API (XML) & Excel

Correct, I would set this up to run hourly or so. I'm looking for the part of that script that grabs the cookie session and manages the login process. Does anyone have any experience with that?

Many thanks,
Willy