REST_GetRecords not working for me.

[apunekar]

const body = {'query': ['PERSON.Last Name;contains;ab']};
    this.fourD.call4DRESTMethod('REST_GetRecords', body)
    .subscribe(
        response => {
          console.log('error:' + response.text());
        },
        error => {
          console.log('error:' + error.text());
        });

Above is the code I am using to get records from PERSON table with last name conatins 'ab'. I am getting 500 Error. I am able to use the fourD.signIn. after this I want to call this method. Its not workin

[fourctv]

@apunekar Is there really a space on that "Last Name" field? Because that is a problem, and is not supported...

Although 4D does support spaces in field names, that is definitely not recommended.

So, either your code is incorrect, or you have to change that field's name.

[amit-punekar-membermax]

@fourctv I modified my code to look something like this

const body = {'tableName': 'PERSON',
                  'Columns': [
                  {'name': 'PERSON ID', 'field': 'PERSON.PERSON ID'},
                  {'name': 'First Name', 'field': 'PERSON.FIRST NAME'},
                  {'name': 'Last Name', 'field': 'PERSON.LAST NAME'}],
                  'QueryString': ['PERSON.Last Name;contains;ab']};
    this.fourD.call4DRESTMethod('REST_GetRecords', body)
    .subscribe(
        response => {
          console.log('error:' + response.text());
        },
        error => {
            console.log('error:' + error.text());
        });

the columns parameter is not working here
$fieldList:=JSON Parse(BLOB to text($columnsList;UTF8 text without length))

fieldList is retuning nil over here....

Regarding the space in the Column Name.. Yes there are spaces in the column name [PERSON]LAST NAME and many moer such columns with space in them.

[fourctv]

why are you using 'call4DRESTMethod' to get records? You should be using a FourDModel instance.
You should create a 'PERSON' FourDModel and then use something like:
let rec:Person = new Person() rec.getRecords(query,columns).then(recList => { ... }

[fourctv]

Take a look at the wiki here:

https://github.com/fourctv/JS44D/wiki/Data-Modelling,-How-to-Generate-a-Model

[apunekar]

Take a look at the wiki here:

https://github.com/fourctv/JS44D/wiki/Data-Modelling,-How-to-Generate-a-Model

Yes I have already generated a model for PERSON table. Ok I will chec kthe solution given by you.. So what do you advise .. when to use 'call4DRESTMethod'?

[fourctv]

"call4DRESTMethod" is to be used to call your own REST entry points. All the REST entry points in the RESTAPI are covered by methods and functions in this JS44D library.
So better to use the proper functions in JS44D, then calling "call4DRESTMethod" manually.

[apunekar]

@fourctv Thanks a lot. Just to go back to your point about having spaces in the field names of the 4D tables I came across a discussion in which we can handle it by adding single quotes to that field. here is the link http://forums.4d.com/Post/EN/25635039/1
I tried it too and its working for me too. Now if you can fix it in your routine RESTParseQuery to add single quotes to all the field and then query using the ds[ ].query() it would fix most of the problems as we have many fields with space in them. I am trying to query the [PERSON]Last Name field , if we can add single quotes and make the $queryString variable or $query variable to look like this "'Last Name = :1 &'", it would work for me

[fourctv]

Sorry @apunekar but allowing spaces in table or field names is against any naming conventions, on any language or development environment. That is a legacy feature of 4D, which they had to keep for compatibility reasons. It is not even supported by 4D's own Wakanda environment.
So, my recommendation is that you eliminate those spaces on all your field names. Keeping that will only cause you trouble in the future.

[amit-punekar-membermax]

@fourctv Thanks Understood. Thanks for the help anyways. Will look forward and change the field names.

[fourctv]

@apunekar glad to be of help. Let me know if you need anything else.

[amit-punekar-membermax]

@fourctv I am try to use the getRecord() and passing the record number as a parameter.
this.fourDModel.getRecord(recordnumber)
.then(recList => {
console.log(recList);
},
error => {
console.log(error);
});
}
It calls the REST_LoadData on the 4D side but checks for table name and returns no records because of table name not found.

[fourctv]

@apunekar you do not use FourDModel class directly. You have to extend FourDModel with your own table classes, and then use them to get/set data from 4D.
See: https://github.com/fourctv/JS44D/wiki/Data-Modelling,-How-to-Generate-a-Model, which explains how you generate your own table classes, which extend FourDModel.

Then you could have something like this, assuming you have a People table:

let myRec:People = new People();
myRec.getRecord(recordnumber)
.then(rec => {
... deal with your record
}

[amit-punekar-membermax]

@fourctv Perfect. Thanks. and what exaactky does this populateModelData() do.
I have called in such way. Is this right ?
const rec: PERSON = new PERSON();
const query = {'query': ['PERSON.Last Name;begins with;ab']};
const columns: string[] = ['PERSON.First Name', 'PERSON.Last Name', 'PERSON.Mail Address1', 'PERSON.Mail City', 'PERSON.Mail State', 'PERSON.Mail Zip'];

rec.getRecords(query, columns)
.then(recList => {
    console.log(recList);
    rec.populateModelData(recList.models);
    this.dataSource = new MatTableDataSource(recList.models);
    this.dataSource.paginator = this.paginator;
    },
  error => {
    console.log(error);
  });