Expand my Community achievements bar.

The Community Ideas review for H1 2025 is out now, see which ideas our Product team prioritized and let us know your thoughts.

Mark Solution

This conversation has been locked due to inactivity. Please create a new post.

SOLVED

Microsoft Dynamics 365 & Workfront Fusion Question - Filters? (How to use standard filters?)

Avatar

Level 3

I am working with the Workfront Fusion Connector "Search Records", specifically leveraging the Entity Type "Contacts" where I am presented with the following:

Filter Options:
(1) Standard Filters
(2) Query Functions (Enter Dynamics 365 web API query functions)


I have selected (1) Standard Filters, where I am presented with Query Options

From the first dropdown, I have selected LAST NAME as the field in Microsoft Dynamics 365 
I have selected the Operator CONTAINS
And the value TEST

Note: I have also tried using the EQUALS Operator. 

I set the Output to be EMAILADDRESS1

In my instance of Microsoft Dynamics 365 I have a Contact record with the Last Name "Test" and an email address of "test@test.com."

However, when I run the module I get the following generic error "Status Code Error: 400"

Any ideas? 


1 Accepted Solution

Avatar

Correct answer by
Level 3

Solved.

When entering the value you need to format it as 'TEST' and not simply TEST. The ' before and after the value to be queried is essential to avoid the 404 error. Hope this simple answer helps other folks. 

View solution in original post

1 Reply

Avatar

Correct answer by
Level 3

Solved.

When entering the value you need to format it as 'TEST' and not simply TEST. The ' before and after the value to be queried is essential to avoid the 404 error. Hope this simple answer helps other folks.