Sep 9, 2020 • Marketo Feature • By Account Manager
Removal of 'is' and 'is not' Operators
Recently Marketo announced that "is" and "is not" operators will no longer be available for float data type fields in Smart Lists and triggers. You can read more about this change and its impact in this community post.
If you are currently using "is" or "is not" for a Float field in a filter, you must change your filter to use a different operator (Marketo recommends "between").
This post addresses the two major pain points:
- How to get a list of all the fields with Float data type?
- How to get a list of "used by" assets for each of these fields?
How to get a list of all the fields with Float data type?
The Marketo UI doesn't let you export a list of all fields with data types — you have to use the API. If you're new to Marketo APIs, watch the webinar "Getting Started with Marketo Engage APIs" first.
Step 1: The API call
Use the Describe Lead endpoint: https://<munchkin-id>.mktorest.com/rest/v1/leads/describe.json?access_token=<access-token>. Replace the munchkin id and access token, hit the URL in your browser, and save the JSON response with a .json extension.
Step 2: Convert JSON to Excel
Convert the JSON to Excel so you can read and filter the float-type fields. On Windows you can import JSON directly into Excel; on Mac, use an online JSON-to-CSV converter. Then filter out the float fields.
How to get a list of "used by" assets for each field?
One way is to search the field by name in Admin → Field Management, but the "used by" list can be long and hard to read. Instead, export the "used by" list via the "Field Action" menu → "Export Used By". You'll get an Excel you can filter by "Used by Type" — for this exercise, only select Smart Lists and Smart Campaigns.
