Discord Embed error

Help
,
1

I’m using MYSQL trigger in order to get info to put into a embed and then send on discord via a webhook.
I keep getting an error and I’m not sure what is causing it.

Current embed format I have
ZFaD30xV

{
  "content": "Buy = 0\nSell = 1",
  "embeds": [
    {
      "title": "Item Shop Transactions",
      "description": "IsSell Value = {{steps.trigger.event.IsSell.data[0]}}",
      "color": 5814783,
      "fields": [
        {
          "name": "ID",
          "value": "{{steps.trigger.event.Id}}",
          "inline": true
        },
        {
          "name": "Steam ID",
          "value": "{{steps.trigger.event.SteamID}}",
          "inline": true
        },
        {
          "name": "Item ID",
          "value": "{{steps.trigger.event.ItemId}}",
          "inline": true
        },
        {
          "name": "Item Name",
          "value": "{{steps.find_row.$return_value[0].ItemName}}",
          "inline": true
        },
        {
          "name": "Amount",
          "value": "{{steps.trigger.event.Amount}}",
          "inline": true
        },
        {
          "name": "Price",
          "value": "{{steps.trigger.event.Price}}",
          "inline": true
        }
      ],
      "footer": {
        "text": "{{steps.trigger.event.CreateDate}}"
      }
    }
  ],
  "attachments": []
}
2

Hi @qjmercer10

First off, welcome to the Pipedream community. Happy to have you!

You may want to watch this video and read the docs on Javascript evaluation.

Your double quotes around strings in your code is causing the string to not evaluate the references to step exports.

If it continues to be an issue, please share the code you’re using to generate this data.

3

Thanks for the reply @pierce I am using a MYSQL new row trigger to get information from a mysql database, then that is transferring to a find row step to get more info based on that, then it all ends up in a send_message_advanced for discord, I get all the data working when using a normal message, but when I use an embed message it breaks. What I provided is the JSON format for making a discord embed. I used the object explorer to get the things btw.

4

So I’ve made some changes, I’ve switched to a bot, however I’m now getting
Error

Request failed with status code 400