Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

SOLVED

Accessing Adobe data from R within Alteryx

gillian_rodger
Level 1
Level 1

Hi there,

I have successfully managed to connect to the Adobe Analytics API and extracted some data through RStudio. I have tried to recreate this process through the Rtool in Alteryx so that this process could be automated but I haven't been able to make this work. Has anybody else attempted this? I haven't been able to find any information online so I don't even know whether this is possible.

Thanks,

Gillian smiley 

1 Accepted Solution
adam_gitzes
Correct answer by
Level 1
Level 1

Hey Gillian,

I haven't mixed the RSiteCatalyst package with Alteryx, but I have automated RSitecatalyst Reporting by creating a batch file that calls my RSiteCatalyst script and scheduling it to run automatically in the Windows Task Scheduler.  It was a couple of years ago, but I believe there was an issue where the RCurl package that RSiteCatalyst uses needed to be explicitly called when used in batch mode, so I'd check just changing your script to make that explicit call and see if it then works in Alteryx.

If not, you can automate your RSiteCatalyst Script produce a csv and then pick that up with Alteryx.  The second answer on this thread (http://bit.ly/1OxGOVq) shows how to run R from command line/batch.  You can then automate your batch file in Windows using these directions (http://bit.ly/1LPR5Wg).  If you have a different OS, simply google "How to schedule a batch file to run automatically in my OS".  

I hope this helps.  Thanks!

View solution in original post

2 Replies
adam_gitzes
Correct answer by
Level 1
Level 1

Hey Gillian,

I haven't mixed the RSiteCatalyst package with Alteryx, but I have automated RSitecatalyst Reporting by creating a batch file that calls my RSiteCatalyst script and scheduling it to run automatically in the Windows Task Scheduler.  It was a couple of years ago, but I believe there was an issue where the RCurl package that RSiteCatalyst uses needed to be explicitly called when used in batch mode, so I'd check just changing your script to make that explicit call and see if it then works in Alteryx.

If not, you can automate your RSiteCatalyst Script produce a csv and then pick that up with Alteryx.  The second answer on this thread (http://bit.ly/1OxGOVq) shows how to run R from command line/batch.  You can then automate your batch file in Windows using these directions (http://bit.ly/1LPR5Wg).  If you have a different OS, simply google "How to schedule a batch file to run automatically in my OS".  

I hope this helps.  Thanks!

View solution in original post

TanmayMathur
Level 10
Level 10

Hi Gillian,

We tried to dig out information but unfortunately there was no source which could help in what you are trying to achieve, I would suggest trying StackOverflow in this scenario.

Thanks.

TM