cancel
Showing results for 
Search instead for 
Did you mean: 

Zoominfo Output fields are missing when mapping in NetSuite

Alwani
Deputy Chef I
Deputy Chef I

Hi,

I have an issue where I have first selected few fields to be mapped to custom field in Netsuite for the Zoominfo.

The output fields are there 

Alwani_0-1709429929571.png

Alwani_1-1709429977777.png

How I can then get the field when field is missing?

Thanks

Ali

 

1 ACCEPTED SOLUTION

julie-reyes
Workato employee
Workato employee

Hi, 

Good day!

As a workaround, these are the steps you can follow:

  1.  Toggle the formula mode of the field in the Netsuite action
  2. Map the Step output datapill from the ZoomInfo action (under the Recipe data widget).
  3. Append ['<field_name>'] in the formula

It should look like this:

Screenshot 2024-05-10 at 8.13.45 PM.png

 

Thank you

View solution in original post

2 REPLIES 2

gary1
Executive Chef III
Executive Chef III

You can use brackets to reference the field by its key name in the JSON.

If the JSON is like this:

{
  "employee_count": 2,
  "primary_industry": "crime",
  "business_model": "grand theft auto"
}

Then you can do this:

[object datapill]["business_model"]

 

julie-reyes
Workato employee
Workato employee

Hi, 

Good day!

As a workaround, these are the steps you can follow:

  1.  Toggle the formula mode of the field in the Netsuite action
  2. Map the Step output datapill from the ZoomInfo action (under the Recipe data widget).
  3. Append ['<field_name>'] in the formula

It should look like this:

Screenshot 2024-05-10 at 8.13.45 PM.png

 

Thank you