FAQs
The Execution Result of the activity is not displayed at runtime
This is because you must be running in background mode. The execution result display is for debugging your workflow activities.
On the Run Project page, do the following:
Make sure that Run in background is turned off.
Select Default as the Server on which to run the job.
Sample Connection Strings
CSVDatabase
oauth settings location=[OAuthSettingsPath];uri=<your csv folder>
Enter your corresponding properties as shown above.
Dynamics 365
azure tenant=fgth3xxT-d456-4090-b0de-9bd1ca2c8101;callback url=http://localhost:12345;edition=Sales;initiate oauth=GETANDREFRESH;oauth client id=1d10f85fg-7ecc-4b7e-8bde-8c740e083665;oauth client secret=xLL8TTTVHOFkiicvQ;oauth grant type=CLIENT;oauth settings location=[OAuthSettingsPath];organization url=https://test.crm.dynamics.com/
Enter your corresponding properties as shown above.
Microsoft Exchange
auth scheme=OAuth;azure tenant=ccgd14c6-d456-4091-b0de-9bd1ca2c8101;callback url=http://localhost:33333;initiate oauth=GETANDREFRESH;oauth client id=ef78e91d-3403-42ea-946d-a77fb0d41439;oauth client secret=NRS9Q~enbyqcFTpmiUnZkXoJqYDyJJPUarT8rani;oauth grant type=CLIENT;oauth settings location=[OAuthSettingsPath];schema=MSGraph
Enter your corresponding properties as shown above
Microsoft SQL Server
Data Source=Server1\SQLEXPRESS;Initial Catalog=Northwind;Integrated Security=True;MultipleActiveResultSets=True
MySQL
Database=sakila; Password="Elur7UTPUpxqsZnsC0tKDg=="; Server=localhost; User=myUserId
Enter your user id, password and security token. Note: password will be encrypted by appRules
Salesforce
auto cache=False;oauth settings location=[OAuthSettingsPath];offline=False;password="vxbT3dBzKnoaki2Dp/WAw==";security token=o4OAsk9n02Hxv2F7J7Zv6jlo;user=admin@appstrategy.com
Enter your user id, password and security token. Note: password will be encrypted by appRules
Snowflake
credentials location=[CredentialsFilePath];database=SNOWFLAKE_SAMPLE_DATA;location=[SchemaSettingsPath];oauth settings location=[OAuthSettingsPath];password=<your password>;url=https://zzz567.snowflakecomputing.com;user=<your userid>;warehouse=COMPUTE_WH
Enter your corresponding properties as shown above.
SQL Azure
Data Source=apprules1324.database.windows.net,1433;Initial Catalog=apprulessqlazure;Persist Security Info=False ;User ID=Admin; Password=pwd;MultipleActiveResultSets=True;Connect Timeout=30;Encrypt=True;TrustServerCertificate=False
Enter your DataSource: Azure<FullServerName>, UserId, Password
Last updated