Expand my Community achievements bar.

Don’t miss the Workfront AMA: System Smarts & Strategic Starts! Ask your questions about keeping Workfront running smoothly, planning enhancements, reporting, or adoption, and get practical insights from Adobe experts.

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.