The ConnectWise Connector for Business Central has access to all the standard ConnectWise fields. If integration with custom fields is required, these steps can be followed.

Find the custom field caption in ConnectWise setup

1. Log into ConnectWise.
2. Navigate to System > Setup Tables.
3. Open the Custom Fields setup table.
4. Open the Screen containing the custom field.
5. Save the Caption for reference in your script below.

Add the Custom Fields array as a Data Source Field

1. Log into SmartConnect > Maintenance > REST Services.
2. Edit the ConnectWise 1.0.0.1 REST Service.
3. Select Service Data Sources and edit the data source you will modify.

4. Select the Fields tab and a new field named customFields with a type of ValueArray as show below.

5. Click Save.

Add a Source Calculation to extract field value

1. On the Service Data Sources > Fields tab scroll to the bottom and click Add Calculated Field
2. Set the Field Name to a name that is easy for you to find.
3. Set the Field Type to String.
4. Enter the below Script in the window.
5. On the second line of script replace Test with the Caption for your field.

//Replace the value below with the caption for your custom field.
var myFieldName= "Test"

//do not edit below code
var list = eval(<<customFields>>);
if(list.length == 0) return '';
for(var I = 0; I < list.length; I++){
  var item = list[I];
  if(item.caption== myFieldName)
    return item.value;
}
return '';

Add Calculation to Data Source fields

1. Navigate to the Data Source setup screen for your data source.
2. Click add data source or select your existing data source.
3. Click Select Fields add the calculated field to the data source.
4. Preview and verify data is returned for the column.
5. Save the data source.