Clay Icon
  • Avatar of Channeled
    Channeled
    APP
    ·
    ·

    This issue might be related to JSON formatting in your HTTP API request body. To troubleshoot, we need to see the exact JSON you're using. Can you copy and paste the JSON body from your HTTP API enrichment into the chat? This will help us identify any formatting issues that might be preventing the last two variables from populating. Also, ensure that: 1. All keys and string values are in double quotes 2. Dynamic variables are correctly formatted (e.g., "/column" for strings, no quotes for numbers) 3. There are no extra commas at the end of your JSON object If you provide the JSON, we can help you spot and fix any formatting issues.

  • Avatar of Clark G.
    Clark G.
    ·
    ·

    { "fullName":"{{fullName}}", "profilePic":"{{profilePic}}", "profileUrl": "{{profileUrl}}", "postUrl": "{{postUrl}}", "postContent":"{{postContent}}", "boardyReply":"{{boardyReply}}", "dateTime":"{{dateTime}}", "firstName":"{{firstName}}", "lastName":"{{lastName}}", "username":"{{username}}", "xFollwers":"{{xFollowers}}", }

  • Avatar of Channeled
    Channeled
    APP
    ·
    ·

    To help troubleshoot your HTTP push issue, could you please copy and paste the JSON body you're using into the chat? This will allow me to check for common formatting errors that might be causing the last two variables not to populate. In general, when dealing with JSON formatting issues: 1. Ensure all keys and string values are in double quotes 2. Check for missing or extra commas 3. Verify proper nesting of objects and arrays 4. Make sure there are no trailing commas Once you share your JSON, we can look at it more closely and identify any potential problems.

  • Avatar of Clark G.
    Clark G.
    ·
    ·

    Not quite

  • Avatar of Bo (.
    Bo (.
    ·
    ·

    Hey Clark, Sorry about this. I wasn’t able to find a person named Ronek or see the row 74 data in your screenshot. Could you point out exactly where it’s happening so we can take a closer look? Also, can you confirm if the missing data is present in Clay, and that Supabase is set up to accept those specific data types? That’ll help us narrow it down.

  • Avatar of Clark G.
    Clark G.
    ·
    ·

    Ah shit just realized I cleared the data. There should be new data in there now though

  • Avatar of Clark G.
    Clark G.
    ·
    ·

    You can use any of the rows

  • Avatar of Clark G.
    Clark G.
    ·
    ·

    The data is present in clay under the username and xFollowers columns

  • Avatar of Bo (.
    Bo (.
    ·
    ·

    Hey Clark, Thanks for the detailed context. I checked the logs and the HTTP push itself completed successfully with a 200 response—so everything on Clay’s side looks good. The issue seems to be with how the username and xFollowers values are being passed. In the payload, xFollwers is misspelled (without an extra “O”), which might be why it’s not populating properly on the receiving end. Here’s what to check: • Double-check the key names in your HTTP body match exactly what Supabase expects (username, xFollowers, etc.). • Make sure the field values in Clay aren’t empty or formatted in a way that Supabase might reject (e.g., unexpected symbols or formatting). Let me know if fixing the key spelling helps—happy to take another look if needed. Full body: '{\n' + ' "fullName": "AK",\n' + ' "profilePic": "[https://pbs.twimg.com/profile_images/1451191636810092553/kpM5Fe12_normal.jpg](https://pbs.twimg.com/profile_images/1451191636810092553/kpM5Fe12_normal.jpg)",\n' + ' "profileUrl": "[https://x.com/_akhaliq](https://x.com/_akhaliq)",\n' + ' "postUrl": "[https://x.com/abidlabs/status/1907163530857722230](https://x.com/abidlabs/status/1907163530857722230)",\n' + ` "postContent": "RT by @_akhaliq: I'm BEYOND EXCITED to announce that after 5 years, we crossed 1 million monthly developers in March. We couldn't have done it without the hackers who took a chance on a new library, the builders who contributed ideas & code to @Gradio, the researchers who used it to showcase…",\n` + ` "boardyReply": "Massive milestone! Gradio's journey from niche ML tool to essential infrastructure is the perfect example of community-driven growth. Congrats to the whole team!",\n` + ' "dateTime": "2025-04-01T16:09:53.000Z",\n' + ' "username": "_akhaliq",\n' + ' "xFollwers": "393.4Kx",\n' + ' "firstName": "AK",\n' + ' "lastName": "AK"\n' + '}',

  • Avatar of Channeled
    Channeled
    APP
    ·
    ·