I am trying to build a simple tool for us to use internally.
We are pulling data from an API which displays from a Keyword DB into the front end. This is called keyword suggestions. Then, we are using an OpenAI API to give us suggestions on content for this keyword. The button is clicked and the API returns the data.
The OpenAI data is saved to a Content DB - how can we get this returned content to be assigned specifically to the keyword row?
As an example, the keyword maybe ‘Crypto currency guide’ and the Keyword DB would store the kw, competition and the difficulty to rank. The content DB would store the content idea for this (IE blog) - I need to then display this in the front end in a row with a toggle interaction to show the content.
Even if its not on the same action? The data is being returned in step one by the API, then in step 2 the user can request the content ideas from the OpenAI api.
How would the API identify the specific keyword row to assign itself to?
Could you maybe post a photo of the page where you are doing this? You can schedule the workflow when the row is clicked and pass that record to the backend workflow
Okay so in your backend workflow, add another field called “suggestion” and pass the “current cells suggestion” from your front-end button press. This will allow you to assign the content to that cell
Now the reason your content is showing an error is its probably not the same data type as what you have defined in your database. If you hover over “content”, does it say it is a text? If you open the issue checker it will tell you what data type you need to convert the content in to allow you to store it
