Sales Force Data Extract

This application takes SOQL Query and runs it against the rest api of Sales Force. The process will then extract the JSON output, convert it to XML to send to a custom Stored Procedure on SQL Server to parse as needed.

Getting Started

To get started with this project, you must have the following installed:

    1. Visual Studio 2017/Visual Studio Code
    2. Dot Net Core 2.1
    3. Pull Project
    4. Restore Nuget Packages
    5. Rebuild project

Prerequisites

What is needed to be installed is the following:

    1. Visual Studio 2017/Visual Studio Code
    2. Dot Net Core 2.1

Installing

A step by step series of examples that tell you how to get a development env running

First

Install Visual Studio/Visual Studio Code

Then

Install Dot Net Core 2.1

Then

Connect to Repository

Pull work project

Change configuration file - Modify the included configuration file.

Change Query file - Layout is as follows:

	1. <* - Optional Comment out Query><Table/FileName><Colon Seperator><SOQL Query>
		i.e *Account:Select ID From Account

Attached is an example of the queries and the configuration

Deployment

Publish application as x64/x86 and move to location required.

Versioning

We use SemVer for versioning.

Authors

• Jason Scherer - Initial work - Jason Scherer

License

This project is licensed under the MIT License - see the LICENSE.md file for details