Hi @luniko 

For us to have full context, post screenshots with how your Zap Code step is configured.

One way to troubleshoot your code is to ask ChatGPT to check/fix based on the error.

The error you're encountering is because of a typo in accessing the keys of the country dictionary. You've used "Country_Nums" and "Country_Names", but the correct keys are "Country_Num" and "Country_Name". Here's the corrected version of your code:

@Troy Tessalone

Thanks for the reply! I see what you’re saying with the keys. I’ve fixed them but I’m still getting the same issues.

Here are some screenshots of the Zap steps that are relevant:
 

1. The Zap looks for the code from the Google sheet cell. Here’s what the test of the Zap returns.

2. Next, I have the step “Run Python in Code by Zapier” running the following action:

   

   
   Here’s the code:

   # Accessing the input data which is provided as 'countries'
   countries_data = input_datat'countries']
   
   # Initializing lists to hold country numbers and names
   country_nums = c]
   country_names = o]
   
   # Iterating over each country in the input data
   for country in countries_data:
       # Appending the country number and name to their respective lists
       country_nums.append(country."Country_Num"])
       country_names.append(country."Country_Name"])
   
   # Preparing the output to include both lists
   output = {'Country_Num': country_nums, 'Country_Name': country_names}
   
   return output
   

3. When I test the code, it still yields this error:

I have tried ChatGPT, but I just end up going in circles and it can’t fix the issue. I’ve even posted on Stackoverflow and people are saying that they don’t see anything wrong with the Python code, but it might be something on Zapier’s end (Referring to a file "<string>")?

I’m truly stumped.

@luniko 

If you need help with configuring the Code step, perhaps consider hiring a Certified Zapier Expert: https://zapier.com/experts

I was able to figure it out.

The issue was the fact that regardless of what is put in as the input data, it comes in as its own value as a string in its own dictionary. 

So my original data goes from this:

countries =  
    {"Country_Num": 1, "Country_Name": "United States"},
    {"Country_Num": 2, "Country_Name": "United Kingdom"},
    {"Country_Num": 3, "Country_Name": "Canada"},
    {"Country_Num": 4, "Country_Name": "Germany"},
    {"Country_Num": 5, "Country_Name": "France"}
]

To being interpreted as this:

{"countries": "countries =  
    {"Country_Num": 1, "Country_Name": "United States"},
    {"Country_Num": 2, "Country_Name": "United Kingdom"},
    {"Country_Num": 3, "Country_Name": "Canada"},
    {"Country_Num": 4, "Country_Name": "Germany"},
    {"Country_Num": 5, "Country_Name": "France"}
]"}

Therefore, I had to get ChatGPT to change the code to the following:

import json


# Extract the JSON-like part from the string
countries_str = input_dataa'countries'].split("countries = "))1].strip()

# Replace single quotes with double quotes to form valid JSON
countries_str = countries_str.replace("'", '"')

# Remove newline and extra spaces
countries_str = "".join(countries_str.split())

# Parse the JSON string into a Python list
countries_data = json.loads(countries_str)

# Initialize lists to hold country numbers and names
country_nums =  ]
country_names =  ]

# Iterate over each country in the input data
for country in countries_data:
    # Append the country number and name to their respective lists
    country_nums.append(countryy"Country_Num"])
    country_names.append(countryy"Country_Name"])

# Prepare the output to include both lists
output = {'Country_Num': country_nums, 'Country_Name': country_names}

return output

This fixed it.