Bea

I did some fiddling around with this so time ago.  https://www.sagecity.com/sage-global-solutions/sage-crm/b/sage-crm-hints-tips-and-tricks/posts/adding-a-button-to-generate-an-sdata-feed-based-on-current-context-using-the-asp-com-api

That the .NET API link the article contains are really only part worked solutions.  Are you trying to have excel look for the data or are you trying to pass the data to excel?

That look good, actually - I'm trying to pass data to excel.

The 'easy' part should be getting Excel to make the call into Sage CRM using the REST API and fetch the data.  That fetch can be managed and controlled by an Excel macro.  The authentication (SID) should be able to be passed from CRM to Excel as a parameter.  The hard part will be calling Excel I think.

The 'easy' part should be getting Excel to make the call into Sage CRM using the REST API and fetch the data.  That fetch can be managed and controlled by an Excel macro.  The authentication (SID) should be able to be passed from CRM to Excel as a parameter.  The hard part will be calling Excel I think.

Happy to call a csv if that is easier

The CSV approach is "from the other end".  I think to create a CSV file you would generate it from Sage CRM.  The code to create the export would sit in CRM.  

Either the .NET or the classic ASP pages could create a CSV output - what would you like?

Classic APS, please!

Hi

I was hoping to take a look at come ASP page code for this?

Bea

I am on holiday today.  I will write some tomorrow.

Thank you very much

I was being foolish - I'd already written about this https://www.sagecity.com/sage-global-solutions/sage-crm/b/sage-crm-hints-tips-and-tricks/posts/exporting-records-to-a-csv-file-using-the-classic-com-asp-api

Thank you so much!