Microsoft Dynamics 365 & Workfront Fusion Question - Filters? (How to use standard filters?) | Community
Skip to main content
Level 3
May 17, 2023
Solved

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

  • May 17, 2023
  • 1 reply
  • 530 views

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? 


This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by shanemckinney13

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. 

1 reply

shanemckinney13AuthorAccepted solution
Level 3
May 18, 2023

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.