- Topics: Active | Unanswered
#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
Offline
#2 2017-04-10 13:57:46
- 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.
Offline
#3 2017-04-13 02:29:54
- 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
Offline