Get all current occurrence field in JSON

Hi everyone.

I'm pretty new to Uniface, so there's a good chance my question is basic, but I tried searching docs and Internet and didn't find the answer.

I also might mixed up correct terms between occurences, entities, etc.. sorry for that, I'll try to be understandable.

I've made a (web)service. In my component, I've painted needed entities et all.

For now, I've made several operations for retrieving datas from a web browser (using VueJS/Ajax). It works, cool.

I've worked mostly this way :

I use the GET parameters to filter the entity, I then loop all occurrencies

lineList = $newstruct
forentity "lf_lines"
    line = $newstruct
    line->$name = "%%no_order.lf_lines"
    line->qty = "%%qty.lf_lines"
    line->article = "%%artcode.lf_lines"
    line->noline = "%%no_line.lf_lines"
    lineList->*{-1} = line
endfor

And then convert my struct to json and send it back with $webinfo("OUTPUT")

For the operation I'm currently working on, I need to get all the field of the entity occurence. That means around 40 fields (for reasons...).

I know for sure I will only have one answer (or zero) because my GET parameters are the primary key.

Is there a way to avoid declare all the field one by one ? Something like converting my answer to JSON (or to struct then to JSON) ?

Thanks in advance for your answers, and don't hesitate to ask me if I'm not clear !

Regards,

JM

The struct MAY need some playing with afterwards but I think you'll get somewhere with :-

componenttostruct v_struct,"YOURENTITYNAME"

This should put all fields of yourentityname into one node per occurrence (so, one node), but you might want to re-name that node to make nice json.... 

Iain

The struct MAY need some playing with afterwards but I think you'll get somewhere with :-

componenttostruct v_struct,"YOURENTITYNAME"

This should put all fields of yourentityname into one node per occurrence (so, one node), but you might want to re-name that node to make nice json.... 

Iain

Hi everyone.

I'm pretty new to Uniface, so there's a good chance my question is basic, but I tried searching docs and Internet and didn't find the answer.

I also might mixed up correct terms between occurences, entities, etc.. sorry for that, I'll try to be understandable.

I've made a (web)service. In my component, I've painted needed entities et all.

For now, I've made several operations for retrieving datas from a web browser (using VueJS/Ajax). It works, cool.

I've worked mostly this way :

I use the GET parameters to filter the entity, I then loop all occurrencies

lineList = $newstruct
forentity "lf_lines"
    line = $newstruct
    line->$name = "%%no_order.lf_lines"
    line->qty = "%%qty.lf_lines"
    line->article = "%%artcode.lf_lines"
    line->noline = "%%no_line.lf_lines"
    lineList->*{-1} = line
endfor

And then convert my struct to json and send it back with $webinfo("OUTPUT")

For the operation I'm currently working on, I need to get all the field of the entity occurence. That means around 40 fields (for reasons...).

I know for sure I will only have one answer (or zero) because my GET parameters are the primary key.

Is there a way to avoid declare all the field one by one ? Something like converting my answer to JSON (or to struct then to JSON) ?

Thanks in advance for your answers, and don't hesitate to ask me if I'm not clear !

Regards,

JM

The struct MAY need some playing with afterwards but I think you'll get somewhere with :-

componenttostruct v_struct,"YOURENTITYNAME"

This should put all fields of yourentityname into one node per occurrence (so, one node), but you might want to re-name that node to make nice json.... 

Iain

The struct MAY need some playing with afterwards but I think you'll get somewhere with :-

componenttostruct v_struct,"YOURENTITYNAME"

This should put all fields of yourentityname into one node per occurrence (so, one node), but you might want to re-name that node to make nice json.... 

Iain

Hi Jean-Marc,

What is your use case? Are you trying to create a REST service that includes update functionality, or just return data in JSON format?

I assume you're looping through occurrences in your code to support any number or matching return occurrences, e.g. a full set or of records, or 0/1 occurrences if the URL contains an ID (which is the case I assume you're referring to).

In either case, instead I would use componentToStruct specifying an entity name to create all retrieved occurrences and fields instead of looping through occurrences, e.g.

componentToStruct vStruct, vEntity

Edit: I see Iain already suggested this by the time I posted my response, but see below for some more information.

You can use the /reconnectTags switch to include some extra information about modification status if you want to use Uniface's inbuilt disconnected record set functionality with updates, but that would need additional changes for JSON usage, so i'll try and keep it simple here.

I would then manipulate the struct to remove the "OCC" tags so it looks more like a normal JSON array, e.g.

vStruct->OCC->$name = ""

Finally I'd use structToJSON to convert the struct to JSON.

I'd also set the response type in HTTP response headers (including others for access control), e.g.

putitem/id $webinfo("HTTPRESPONSEHEADERS"),"Content-Type", "application/json"

Regards,
David

The struct MAY need some playing with afterwards but I think you'll get somewhere with :-

componenttostruct v_struct,"YOURENTITYNAME"

This should put all fields of yourentityname into one node per occurrence (so, one node), but you might want to re-name that node to make nice json.... 

Iain

The struct MAY need some playing with afterwards but I think you'll get somewhere with :-

componenttostruct v_struct,"YOURENTITYNAME"

This should put all fields of yourentityname into one node per occurrence (so, one node), but you might want to re-name that node to make nice json.... 

Iain