How to send Glide Records after quering database from Script Include in JSON format
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎04-02-2024 10:47 PM
I have a requirement to Glide a table with specific conditions and result of that query ie records of that table should be returned in JSON Format.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎04-02-2024 11:12 PM
Really appreciate that..I was able to crack the code till the same point. but where i am facing the difficulty is I need to push whole user record instead of two fields in an object and I need to get those user record values in the client side.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎04-02-2024 11:22 PM
Hi @G Sai Vamshi what do you mean whole record? you want all the fields? then you need to push all the fields like below
userInform.field1= gr.getValue("field1");
userInform.field2= gr.getValue("field2");
userInform.field3= gr.getValue("field3");
so on
and finaly push all records
userData.push(userInform);
and in client script you need to parse the answer like below
Please provide your use case in detail to assist further.
Harish

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎04-02-2024 11:29 PM
Hi @G Sai Vamshi another way to get all fields is like this but consider performance issue here, do you really want to send all fields?
script:
Harish