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=[e-mail]

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