Salesforce Update Fields - Data Type of System.Single

Help Studio
, ,
1

We are newly implementing with UiPath and are automating Salesforce activities. When we update a field using the Salesforce Update and integration services connection, large numbers are losing precision due to the DataType of System.Single. Has anyone found a work around that utilizes the Salesforce API or is UI automation via a browser the more reliable solution?

image
image786×233 10.6 KB

2

When you’re working with Salesforce and UiPath, and you encounter issues with data types, such as precision loss with System.Single, there are a few approaches you can take to handle this situation:

  1. Use Decimal Data Type*: If possible, change the data type from System.Single to System.Decimal within your automation workflow. The Decimal type has a greater precision and is more suitable for financial calculations.
  2. Salesforce Activity Pack*: Make sure you are using the latest version of the UiPath Salesforce Activity Pack, which might have specific activities or properties to handle precision correctly.
  3. Salesforce API*: If the standard activities do not meet your precision requirements, consider using the Salesforce API directly. You can call the API using the HTTP Request activity in UiPath to perform the update operation, ensuring that you format the number as a Decimal in the JSON payload.
  4. Custom Code Activity*: You can use an Invoke Code activity in UiPath to write custom .NET code that updates the Salesforce field using the API, which allows you to control the data type and format explicitly.
  5. UI Automation*: If all else fails, automating the Salesforce web interface using UiPath’s browser activities is a last resort. This is less reliable than API integration due to potential changes in the UI and slower performance but can be a temporary workaround.
1 Like
3

I am not sure which activity you are using but for me I prefer to use the Update Record (or Insert record if its a new record). This way all your organization fields are available with their actual datatype

4

We are using the Update Record activity.

5

Thank you for all the suggestions.

6

I’m adding the fields from the activity itself and not from the properties pane. It’s easier there as you would just need to pick the fields from your org.
image