Expand my Community achievements bar.

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.