Issue with Invoking Python Method for Date Field Conversion in UiPath

Help Studio
,
1

Hello UiPath Community,

I hope this message finds you well. I am currently facing an issue while trying to invoke a Python method inside UiPath for the conversion of date fields, and I was hoping to get some guidance or insights from the community.
Problem Description: I have a workflow where I need to convert date fields using a Python method. However, when I try to invoke the Python method within UiPath, I encounter errors, and the conversion is not successful. The date format is crucial for further processing, and resolving this issue is essential for the overall success of the automation.

image
image1505×845 44.2 KB

Error Message: I am receiving an error message that says Error Invoking Python method. I’ve double-checked my Python script, and it works correctly when executed outside UiPath. It seems like there might be a compatibility or configuration issue when trying to invoke this Python script within the UiPath workflow.

What I’ve Tried So Far:

  1. Checked the Python script independently to ensure it works as expected.
  2. Verified the input parameters being passed to the Python script from UiPath.
  3. Explored potential issues with the Python environment or dependencies.

would appreciate any guidance or suggestions from the community regarding this issue. If anyone has successfully invoked Python methods for date field conversion within UiPath or has insights into potential pitfalls, please share your experiences.

Your assistance is highly valued, and I believe that together, we can troubleshoot and resolve this issue. Thank you in advance for your time and support.

Best regards,
Divyanshu

2

Hi @divyanshu52,

Can you share the python code you’re trying to execute

3

import datetime

def convert_date(headerFieldname,company_name):
date = datetime.datetime.strptime(str(headerFieldname), “%Y%m%d”)
date_format = “”
if company_name == “WDF”:
date_format = “%d %b %Y”
elif company_name == “TESCO”:
date_format = “%d %b %y”
elif company_name == “DEEREHITACHI”:
date_format = “%m/%d/%Y”
elif company_name == “D”:
date_format = “%Y/%m/%d”
elif company_name == “TARGET CORPORATION”:
date_format = “%m/%d/%Y”
elif company_name == “DISCOUNTTIRE”:
date_format = “%m/%d/%Y”
else:
date_format = “%Y%m%d”

new_headerFieldname = date.strftime(date_format) 
return new_headerFieldname
4

@divyanshu52

Can you also share the properties of Invoke Python Method activity

5

INVOKE Python Method - Parameters

image
image944×720 32.2 KB

INVOKE Python Method - Properties

image

6

@divyanshu52

Try passing the parameters as array of string, for example

{"datefield", "name"}

Cheers