Clay Icon
  • Avatar of Channeled
    Channeled
    APP
    ·
    ·

    This issue might be related to invalid or conflicting data configurations in your mappings. Here's how you can resolve it: 1. First, check your API key configuration: • Go to Settings > Connections • Search for Clay and verify your API key is properly connected 2. If you're still experiencing issues, the error may be due to: • Writing to deleted columns • Sending data to tables that reference another tableTo fix this: 1. Reconfigure your Write to Table integrations 2. Verify all columns and tables exist and are properly set up 3. Remove and re-add the integrations to clear any misconfigurationsIf these steps don't resolve your issue, please explicitly ask for a human agent in this conversation for further assistance, as this may require direct investigation of your specific setup. Source: Write to table integration overview | Documentation | Clay University

  • Avatar of Tanvi R.
    Tanvi R.
    ·
    ·

    Hi Ben, thanks for reaching out! Happy to take a look here for you

  • Avatar of Tanvi R.
    Tanvi R.
    ·
    ·

    Hey Ben, I just deleted the input and re-added it to write to table and it saved correctly. Please try running this now and let us know if you have any further questions!

  • Avatar of Ben H.
    Ben H.
    ·
    ·

    I’ve done this a tonne of times

  • Avatar of Ben H.
    Ben H.
    ·
    ·

    The error keeps coming back

  • Avatar of Ben H.
    Ben H.
    ·
    ·

    This is for a client project and I’m trying to get it signed off, but don’t feel confident with it in this state

  • Avatar of Tanvi R.
    Tanvi R.
    ·
    ·

    t looks like this might just be a user interface bug, when I check the table it is writing to I see both of these columns are filled and have values. Let me know if there are any incorrect results you're seeing

  • Avatar of Ben H.
    Ben H.
    ·
    ·

    Ok cool so I should be able to run the table regardless? It’s just the domain’s important for the flow so i don’t want it to mess anything up

  • Avatar of Tanvi R.
    Tanvi R.
    ·
    ·

    Yes you should be able to run the table correctly

  • Avatar of Channeled
    Channeled
    APP
    ·
    ·

    Hey there - just wanted to check in here to see if you needed anything else! Feel free to reply back here if you do.

  • Avatar of Channeled
    Channeled
    APP
    ·
    ·

    We haven't heard back from you in a bit, so we're going to go ahead and close things out here - feel free to let us know if you still need something!

  • Avatar of Channeled
    Channeled
    APP
    ·
    ·

    Hi Ben H.! This thread was recently closed by our Support team. If you have a moment, please share your feedback:

  • Avatar of Channeled
    Channeled
    APP
    ·
    ·

    Thanks! We've reopened this thread. You can continue to add more detail directly in this thread.

  • Avatar of Ben H.
    Ben H.
    ·
    ·

    Ok this definitely did not run the table correctly and has caused significant disruption to my clients project & cost a lot of resource/credits (external to Clay).

  • Avatar of Ben H.
    Ben H.
    ·
    ·

    https://app.clay.com/workspaces/339655/tables/t_HTyvPq4TobGm/views/gv_vWDA8ME8seeo All of the fields were correctly mapped, and now the bug is back, the domain has been unmapped for some reason now too (1-24 & Prospect - Go Sell Wireless) I haven’t checked the others, but I’ve just received a complaint from the client about this

  • Avatar of Ben H.
    Ben H.
    ·
    ·

    Please can you look into this ASAP.

  • Avatar of Ben H.
    Ben H.
    ·
    ·

    Hey Tanvi R. / team, any updates on this please?

  • Avatar of Bo (.
    Bo (.
    ·
    ·

    Hey Ben, thanks for reaching out. I get how frustrating this must be, especially with the client impact. Our team is actively looking into this. Can you let me know exactly which columns weren't mapped correctly? Specifically, which ones ended up in the wrong place? That'll help us tremendously. In the meantime, can you try a hard refresh (Cmd + Shift + R). If that doesn't fix it, make sure to re-select the last column selector before saving a new enrichment. Once I hear back from you, I'm happy to cover the credit costs - just let me know what the total was. We'll keep you posted as we go as well.

  • Avatar of Ben H.
    Ben H.
    ·
    ·

    Hey Bo (., thanks for getting back to me. Appreciate the credit option, but all of this is with HTTP external providers, I don’t think we’ve spent a Clay credit yet for this project. AT&T - Master Table:

    • It’s really hard to say which columns aren’t mapped correctly, they behave very sporadically and I’ve updated (fixed) these over 5 times, only for it to break again, as mentioned in my previous comment above.

    • It keeps changing which ones are unmapped, but if you go through each of the ‘Write to Other Table’ enrichments, you’ll see the bug present on pretty much all of them. These all need to be fixed & amended please.

    • For example: 1-24 & Wireless - Go Sell Fiber: ‘Employee Range Formula’ & ‘title’ have been unmapped

    Request: If your team could please do the following, this would be GREATLY appreciated.

    1. 1.

      AT&T - Master Table: move all values from phone_type to the Phone Type column (this wasn’t you guys, my client made an error, but I’d appreciate it nonetheless).

    2. 2.

      Make sure that all of the ‘Write to Other Table’ enrichments are fixed & error free. They should all have (at a minimum):

    1. a.

      first_name

    2. b.

      last_name

    3. c.

      Phone Number

    4. d.

      Phone Type

    5. e.

      Normalized Name

    6. f.

      Normalizedurl

    7. g.

      Employee Range Formula

    1. 3.

      If the Company Domain, Phone Type & Employee Range Formula fields could now be sent/remapped back over to the other tables to fill in the gaps (where they’ve been missed in the incorrect mapping), that would be huge.

    Hopefully that explains everything ok? Happy to send over a Loom or something if that’s more useful.

  • Avatar of Bo (.
    Bo (.
    ·
    ·

    Hey Ben, The team isn't entirely sure where this is coming from, but we've found a workaround: 1. Try a hard refresh (Cmd + Shift + R). 2. If that doesn't fix it, manually re-set the last column selector before saving any new enrichment. 3. Alternatively, try duplicating the column and mapping it again. Fix timeline: TBD—our team is actively working on it. Regarding the Write to Other Table enrichments, we won't be able to re-map the data inside the table directly. The best approach is to go into the table and re-run the Write to Other Table enrichment. Happy to do this, but I'd recommend you try it first since it can trigger multiple enrichments and you would be the most aware. The write to other table should also work. This bug seems to be currently only aesthetics. But if you see columns not going to the right spot, please report it directly to us. Let me know if you need more help!

  • Avatar of Ben H.
    Ben H.
    ·
    ·

    Hey Bo (., with respect this is exactly what was suggested before by the previous colleague - I was told it was just a visual error so I persisted, and this is what caused all of the rows to be messed up. I hope you understand that I really don’t want to run into the same issue again as it’s costing me a tonne of time with this client

  • Avatar of Ben H.
    Ben H.
    ·
    ·

    I’ve just tried all 3 solutions and none of them are working, something real weird is going on here. They’re ‘working’ for a few minutes, and then they start erroring again. I don’t want to run any data through this as I’m concerned it’s going to mess things up even more

  • Avatar of Bruno R.
    Bruno R.
    ·
    ·

    Ben - Sorry for this, it looks like we've got a bug on our hands. I've escalated this to our engineering team to help look into it. We'll follow up here as soon as we know more!

  • Avatar of Ben H.
    Ben H.
    ·
    ·

    Thanks Bruno

  • Avatar of Ben H.
    Ben H.
    ·
    ·

    Please keep me updated as our client is spending a good amount each month on email accs etc while this isn’t live

  • Avatar of Bruno R.
    Bruno R.
    ·
    ·

    We will be in touch as soon as we have news, thank you for your patience Ben!

  • Avatar of Ben H.
    Ben H.
    ·
    ·

    Thanks Bruno

  • Avatar of LuisArturo
    LuisArturo
    ·
    ·

    Hey there Ben, jumping in to let you know that we have ushed out a fix for this.

  • Avatar of Channeled
    Channeled
    APP
    ·
    ·

    Hi Ben H.! This thread was recently closed by our Support team. If you have a moment, please share your feedback:

  • Avatar of Ben H.
    Ben H.
    ·
    ·

    Thanks LuisArturo & Bruno R. Understandably my client isn’t overly happy as we’re going to have to run 20k rows again (which has cost him due to using external vendors through API). Is there anything we can offer in terms of reimbursement here? Just to be clear I’m not benefitting here at all, this is his account. I just want to smooth this over as much as possible.

  • Avatar of LuisArturo
    LuisArturo
    ·
    ·

    Hey there Ben just to confirm this is for the Nucomm workspace correct?

  • Avatar of Ben H.
    Ben H.
    ·
    ·

    Hey this is correct

  • Avatar of LuisArturo
    LuisArturo
    ·
    ·

    Hey there Ben just added some credits to the workspace, for this situation.