Skip to main content
Best answer

Issue with 'Code By Zapier' Test Results Not Updating in 'Add Row in Excel'

  • September 17, 2024
  • 4 replies
  • 20 views

Hello Zapier Experts !

I have a Zap where an AI assistant generates a precise JSON, which is then sent to the next step, 'Code By Zapier', where a Python script processes the JSON data. The goal is for the data processed by the Python script to be distributed into specific cells and rows in Excel using the 'Add Row' function.

My problem is: when I test my code in 'Code By Zapier', the test results display correctly in the 'Data Out' tab. However, when I try to select a value from the test in the 'Add Row' step, 'Code By Zapier' only offers me completely different test results from a previous attempt.

I have already tried the following steps:

  1. Cleared previous test data.
  2. Refreshed the inputs and outputs.
  3. Re-authorized steps.
  4. Ensured the data format is correct.
  5. Tested with simplified data.

Despite all these efforts, the issue persists. Could you please advise on how to resolve this issue?

I cannot share screenshots due to confidentiality reasons of the company I work for.

Thank you for your assistance :) 

PS : sorry about my English, it’s not my main language.

Best answer by VooDoo

Hey Everyone,

I sorted this issue out, I just had to re-arrange my Python, to be more precise I had to reorganize the data output format. It seems that my problem is solved. 

Thank you very much :) 

Voodoo

View original
Did this topic help you find an answer to your question?

4 replies

Troy Tessalone
Forum|alt.badge.img+14
  • Zapier Expert
  • 30744 replies
  • September 17, 2024

Hi @VooDoo 

For us to have more info, post screenshots with how your Zap steps are outlined and configured in EDIT mode along with the DATA OUT from the Zap Code step.


  • Author
  • Beginner
  • 2 replies
  • September 18, 2024

Hi @Troy Tessalone 

Here are the screenshots you asked for : 

Is there anything else I can do to help you ? 

As you can see the data out from the code by Zapier is totally different in the “Add Row”. 

Many thanks in advance :) 

 


  • Author
  • Beginner
  • 2 replies
  • Answer
  • September 18, 2024

Hey Everyone,

I sorted this issue out, I just had to re-arrange my Python, to be more precise I had to reorganize the data output format. It seems that my problem is solved. 

Thank you very much :) 

Voodoo


SamB
Community Manager
Forum|alt.badge.img+11
  • Community Manager
  • 7304 replies
  • September 19, 2024

YAY! That’s really fantastic news, @VooDoo! Great work on getting this solved. 🙌

Please do reach back out to the Community in future if you need help at all. Until then, happy Zapping! ⚡