In this example, we shall create a new set of records in an MS Dynamics 365 Sales DB table, view the output preview, and delete the data using a Dynamics 365 For Sales Delete Snap. This way, we can see each of these Snaps in action and learn how to work with them, while leaving the sample pipeline ready for reuse.
Step 1: Prepare Records for Upload
In this example, we are using the JSON Generator Snap to create and store records to be uploaded to the MS Dynamics 365 Sales DB table. You can also use a Mapper Snap to send in the data needed to create the records.
Step 2: Create Records in the MS Dynamics 365 Sales DB Table
Connect a Dynamics 365 For Sales Create Snap to the JSON Generator Snap and configure it to add new records into the as follows:
Step 3: Map '$accountid' in Created Records to '$guid' to simplify identification
We intend to delete the records we just created. To simplify isolating these records, we map the '$accountid' attribute in these records to '$guid', so we can search for these records by '$guid' and delete them later in the pipeline.
Step 4: Delete all Account Records with Attribute '$guid'
Now that we have replaced the attribute '$accountid' with '$guid', we can perform a simple delete operation, removing all records that contain the '$guid' attribute:
Download the sample pipeline