Error with request

[rudvfaden]

I am getting an ERROR trying to pass some data to the adapter. I have this function.

  save() {

    let myData = this.dataejers.map((row: dataRows) => {
      return { FREKVENS: row.FREKVENS }
    });
    console.log(myData)
    this.sasService.request('common/updatedata', myData).then(() => {

    })
  }

My data has one col.

I am getting this error:

ERROR Error: Uncaught (in promise): r: {"error":{"message":"First letter of table should be alphabet or underscore.","details":""}}
    at resolvePromise (zone.js:1211:31)
    at resolvePromise (zone.js:1165:17)
    at zone.js:1278:17
    at _ZoneDelegate.invokeTask (zone.js:406:31)
    at Object.onInvokeTask (core.mjs:25535:33)
    at _ZoneDelegate.invokeTask (zone.js:405:60)
    at Zone.runTask (zone.js:178:47)
    at drainMicroTaskQueue (zone.js:585:35)
    at ZoneTask.invokeTask [as invoke] (zone.js:491:21)
    at invokeTask (zone.js:1661:18)

Any idea of what is wrong?

[allanbowe]

Hi Rud - your data object should contain a series of table arrays. The name of each array will become the SAS table name.

Each table array contains a series of row objects.

The stringified JSON should look like this (assuming your table is called "sdfvc" and your column is "FREKVENS":

{
	"sdfvc": [{
		"FREKVENS": "PRIMO_BANKDAG_MDR"
	}, {
		"FREKVENS": "PRIMO_BANKDAG_MDR"
	}, {
		"FREKVENS": "PRIMO_BANKDAG_MDR"
	}]
}

More info here: https://sasjs.io/sasjs-adapter/#request-response

[allanbowe]

Hi @rudvfaden - we've updated the adapter to give a more helpful error message when this issue occurs.

[rudvfaden]

Do you have a suggestion on how to get this returned from a html table? fre. 22. jul. 2022 15.30 skrev Allan Bowe ***@***.***>:

…

Hi Rud - your data object should contain a series of table objects. The name of each object will become your SAS table name. Each table object contains an array of row objects. The stringified JSON should look like this (assuming your table is called "sdfvc" and your column is "FREKVENS": { "sdfvc": [{ "FREKVENS": "PRIMO_BANKDAG_MDR" }, { "FREKVENS": "PRIMO_BANKDAG_MDR" }, { "FREKVENS": "PRIMO_BANKDAG_MDR" }] } — Reply to this email directly, view it on GitHub <#740 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/AASVCCPKHQFTDFIOSMFEB3DVVKPAFANCNFSM54LM4I2Q> . You are receiving this because you authored the thread.Message ID: ***@***.***>

[allanbowe]

Hi @rudvfaden - this is a question best suited for the SASjs Support channel, as it's not specifically adapter related: https://matrix.to/#/#sasjs:4gl.io

Will look to get you an answer there

[rudvfaden]

Old issue. You can close it.