Automating data import from API(CSV format) into CRM RRS feed

  • Question

  • Hi there,

    I'm new to this forum, so I hope this is the right place to ask this question, and if I've missed any important information needed for you to give a fulfilling answer please let me know :)

    I'm completely new to Dynamics CRM, so I would like to get some advice on how to automate the following process in Dynamics:

    I must consume an API which generates a csv-file containing different payment information related to individuals who have donated money to the company.

    The csv-file contains lots of columns of which I only need to use a few, so I have to select only the data from these few desired columns. Using the data from these columns I then have to then update the data model in Dynamics CRM.

    New donations come in every day, so this process should be automated to run every night at 00:00 AM, when no one is at work and will be affected by it.

    I hope my description suffice, otherwise please let me know.

    Looking forward to get your help

    Best Regards,

    Wednesday, March 9, 2016 7:21 PM