Performing Advanced Lookup against Dynamics 365 CDS/CRM using the Premium Service Lookup Component
Our Dynamics 365 toolkit offers an in-place lookup feature that provides many unique capabilities in supporting various lookup requirements. While the feature is extremely flexible and easy to use, there are certain limitations, such as it cannot be used in a transformation component, and it can support up to 2 different fields you can look up against for reach lookup configuration. In this blog post, we will demonstrate how you can use our recently released Premium Service Lookup component to perform some more advanced lookup scenarios when working with Dynamics 365 CDS/CRM/CE/Dataverse connections.
Extracting HTML Table Contents from Email Bodies
There might be cases where you would be receiving emails with some tables contained in the email body and you are tasked to extract data from those tables and transform them into a flat file or otherwise a database table. This can be a challenging situation without proper tools. In this blog post, we will demonstrate how to extract tables structures from an email using the Email Source component and HTML Table Source component from the KingswaySoft SSIS Productivity Pack.