Struggling writing data from Pro-code app to dataset (appending data)

Larry_Goodwin
Larry_Goodwin Member
in Apps

Attached is part of my app project where I am writing out a row to my dataset upon submittion by the user.

Goal is to track the submission for use in reporting and other automations.

Row will be used in a workflow to fire off API requests and ultimately submit a Jira ticket for the user who submits this in a secure process.

Attaching:

  1. Manifest image
  2. App.js snippets
    1. Calling the datasets - Even went as far as hardcoding them
    2. Writing the output
  3. Postman - dataset schema
  4. Postman - Results from dataset creation
  5. Inspection Console Log for "Submit" function.

I am sure it is simple somewhere, but I am not finding how after days of beating on it.

manifest.png Postman - datset create.png app js image 1.png app js image 2.png
submissions dataset schema.txt
console log on submit.png

Answers

  • Larry_Goodwin
    Larry_Goodwin Member

    Any thoughts or ideas are welcome!

  • ArborRose
    ArborRose Coach

    You are using: domo.post(/data/v1/${datasetId}, [submission])
    but I don't see where you are running this as a brick or app. Have you deployed this as a app within Domo?

    We can't see the whole manifest in your screenshot. Do you have it set to write? Otherwise, it might be treated as read-only.

    "dataSets": [
    
  {
    
    "name": "submissions",
    
    "id": "4924fe6b-b1c2-4182-abea-dee15d9c2702",
    
    "type": "WRITE"
    
  }
    
]

    Right before your screenshot marked as "This is killing me!", maybe add another console debug statement to verify the datasetID is valid. If you don't get an id response, it would indicate Domo didn't load the dataset properly from the manifest.

    const datasetId = datasets['submissions'];
    
console.log('Submissions dataset ID:', datasetId);

    ** Was this post helpful? Click Agree or Like below. **
    ** Did this solve your problem? Accept it as a solution! **

  • Larry_Goodwin
    Larry_Goodwin Member

    For the manifest, I used the GUI to connect them. Did not see in any of the documentation about the type of WRITE, I missed that unless it is somewhere else.

    Here is the GUI and the JSON

    Manifest 06242025.png Manifest json 06242025.png

    and I clearly see it is not there in the Json.

    For the dataset verification, the console log is showing the correct ID as seen in the third green check below.

    console log on submit.png

    Next test: Update manifest to ensure write. Will report back

  • ArborRose
    ArborRose Coach

    Have you tried using the Rest API with append?

    POST https://api.domo.com/v1/datasets/{datasetId}/data?updateMethod=APPEND

    You mentioned looking for reference page. https://developer.domo.com/docs/tools/domo-js

    ** Was this post helpful? Click Agree or Like below. **
    ** Did this solve your problem? Accept it as a solution! **

  • Larry_Goodwin
    Larry_Goodwin Member

    ok, modified manifest to add the write

    app_js2.txt
    Manifest update 06242025.png image.png

    just got the error above again.

Categories