• Documentation
  • Workato Blog
  • Product Blog
  • Return to Workato
  • Login
  • Automation Institute
  • Documentation
  • Community Forums
New Topic
Discussions Recipe Building Formula Mode Questions
M

Michael Burstein

started a topic almost 4 years ago

Set null/blank value in Active Directory

I'm using the Active Directory: Update User action to update user attributes based on changes within Workday.   I have a list of 10 or so fields that get updated, however not all of them are *required.  For example, the accountExpires attribute is only set for contractors so for most employees it would actually be blank.


The challenge is that Active Directory throws an error when setting a blank value "".  I've googled around and tried setting the following values for the blank per recommendations:

  • ""
  • null
  • $null
  • @()
  • []
  • "[]"

All of these return an error.

Does anyone have any insight on how to actually set a blank value for Active Directory through Workato?

Also, is there a way to exclude blank values from your input JSON all together?  i.e. let's say my update action is looking for the following fields:
  • Name
  • Title
  • Account Expiration

If my Account Expiration is blank I should be able to send just:

 

entry: {
	name: "John Doe",
	title: "Business Manager"
}

  

Any insight would be greatly appreciated.

C

Chandra Vippena

said almost 4 years ago

For Active Directory, you should able to set accountExpires to "0". 

{
  accountExpires: "0"
}

 

Also, you can use skip to exclude attribute in the request.

Login to post a comment

Still can't find your solution?

Send us a ticket, we will try our best to assist you with your problem

Documentation
Developer's Library
Tutorials
eBooks
Product Hour
Product Blog
Workato Blog
Product updates
Customer Stories
© Workato 2022   Privacy   Terms   +1 (844) 469-6752
  • Documentation
  • Workato Blog
  • Product Blog
  • Solutions
  • Forums
  • Tickets
  • Log in
  • Return to Workato
Topic views count