topic Re: Adding hyperlink field, syntax error in url in Python Questions

Adding hyperlink field, syntax error in url

ErichSchreier — Tue, 01 Nov 2022 17:59:46 GMT

Hello!

I am trying to add a hyperlink field to a feature class so I can use it in a pop-up on a viewer. The issue I am having is with the url itself; I receive an invalid syntax error on the url.

The feature class has a 'LINK ID' field, which is a number that sits at the end of a base url. So what I need to do is add a field for the hyperlink (I got that to work just fine), and then calculate this field by concatenating the base url string with the Link ID field. Here is the line of the code that is failing:

arcpy.management.CalculateField(fc, 'HYPERLINK', 'https://msc.fema.gov/portal/downloadProduct?productID='+'LINKID ', "Python 3")

I have tried using .format methods as well, and continue to receive invalid syntax on the url. Any help is appreciated, thank you!

Re: Adding hyperlink field, syntax error in url

Anonymous User — Tue, 01 Nov 2022 18:19:38 GMT

Looks like you have a space between the D and '.

I take it LINKID is a number... Might try casting to string. str(LINKID) I know you tried format, but sometimes you just need to be explicit.

Re: Adding hyperlink field, syntax error in url

dgiersz_cuyahoga — Tue, 01 Nov 2022 18:31:43 GMT

LinkID needs to be between exclamation points.

arcpy.management.CalculateField(fc, 'HYPERLINK', '"https://msc.fema.gov/portal/downloadProduct?productID="+!LINKID!', "Python 3")

Re: Adding hyperlink field, syntax error in url

ErichSchreier — Tue, 01 Nov 2022 18:45:24 GMT

Thanks for the response! I should have been a bit more clear, the syntax error is in the url itself. It does not like the semicolon after the https.

Yep, the link id is a number that will be added on to then end of the url.

Re: Adding hyperlink field, syntax error in url

Anonymous User — Wed, 02 Nov 2022 01:02:41 GMT

I did a little local test and replicated the issue. Using the ! surrounding the field returned an eol expected error as well. Seeing that you are using this in a standalone script, I'd just use an update cursor:

with arcpy.da.UpdateCursor(fc, ['HYPERLINK', 'LINKID']) as uCur: for row in uCur: row[0] = fr'https://msc.fema.gov/portal/downloadProduct?productID={row[1]}' uCur.updateRow(row)

Re: Adding hyperlink field, syntax error in url

JohannesLindner — Wed, 02 Nov 2022 07:42:39 GMT

Using Calculate Field in a Python script is a little tricky.

As already said, you have to enclose field names with exclamation marks.
What @dgiersz_cuyahoga did in his answer but didn't actually say: You have to supply the expression as a string. Your expression is (almost) correct when you use it in the Python window. For it to work in the tool, you have to turn it into a string. Just surround it with quotes (the type you didn't use in the expression, or triple quotes):

# this works in a Python console, assuming LINKID is a defined variable 'https://msc.fema.gov/portal/downloadProduct?productID=' + str(LINKID) # or with newer syntax f'https://msc.fema.gov/portal/downloadProduct?productID={LINKID}' # for Calculate field, you have to supply the expression as string "'https://msc.fema.gov/portal/downloadProduct?productID=' + str(!LINKID!)" "f'https://msc.fema.gov/portal/downloadProduct?productID={!LINKID!}'"

Re: Adding hyperlink field, syntax error in url

ErichSchreier — Wed, 02 Nov 2022 16:44:30 GMT

Thanks Jeff! The simple syntax in Johannes' answer was a quick fix, but I will certainly be keeping the update cursor in my mind for future projects.

Re: Adding hyperlink field, syntax error in url

ErichSchreier — Wed, 02 Nov 2022 16:45:20 GMT

Thanks Johannes, exactly what I needed!