Home Salesforce Integrate Salesforce Stackexchange using Lightning Web Component and Apex

Integrate Salesforce Stackexchange using Lightning Web Component and Apex

by Dhanik Lal Sahni

Salesforce Stack Exchange is dedicated community site for Salesforce developer to get answers of all question. This community has lot of members who helps in resolving issues.  This post is showing how we can get list of all members of this community.

We are using Salesforce Stack Exchange API to get members list using Apex. Members list is being shown using Lightning Web Component in lightning community.  I have named this community as Salesforce Stackexchange User Explorer  and can be accessed at https://dhanik-stackoverflow-developer-edition.ap15.force.com/stackexplorer/s/

Salesforce Stack Exchange API :

https://api.stackexchange.com/2.2/users API is used to get user list in Apex. We can pass different parameter to this API to get required list. We can do sorting, pagination as well as we can get list of members from other group as well like freelancing, stackoverflow etc.

Apex Code to get members list


We have to create wrapper class to get members list. Wrapper class can be created using https://json2apex.herokuapp.com/

Lightning Web Component to show users

Let us create Lightning Web Component to show list of members. I have created two combo box in this component. One combo box is showing group name like salesforce, stackoverflow and freelancing for which we need to show user.

 get options() {
        return [
            { label: 'Salesforce', value: 'salesforce' },
            { label: 'Stackoverflow', value: 'stackoverflow' },
            { label: 'Freelancing', value: 'freelancing' },
        ];
    }

Second combo will show order field name.

 get fields() {
        return [
            { label: 'Reputaion', value: 'reputation' },
            { label: 'Name', value: 'name' }
        ];
    }

I have used lightning-datatable to show members list in grid.

We have to show creation date and badge count on table. For this we have to change JSON data and date format after receiving from Apex.

.then(result => {
            for (let i = 0; i < result.items.length; i++) {
                let row = result.items[i];
                row.silver = row.badge_counts.silver; 
                row.gold = row.badge_counts.gold;
                row.bronze = row.badge_counts.bronze;  //create field from dependent object
                row.date = new Date(parseInt(row.creation_date.substr(6)));  //Format date
            }
            this.data = result.items;
            this.error = undefined;
            console.log(result.items);
        })

Complete Code of this component

Lightning Web Component for Pagination

We have to create pagination button like next, previous to get next pagination records. I have created another lightning web  component for this. Handler of these button is passed from main lightning web component.

Complete Code of this component

Demo Time:

Reference:

https://api.stackexchange.com/docs/users

https://developer.salesforce.com/docs/component-library/overview/components

You may also like

2 comments

Ram September 12, 2022 - 12:10 pm

Hi DHANIK, Thank you for that awesome post, just a quick question I need your help with, for the field that has image , is it returning an HTML tag, like for example ( ) and you reading it, if not , do you know how to read that HTML stage from formula field, please?

Reply
Dhanik Lal Sahni September 14, 2022 - 6:59 pm

Hello,

Not able to understand your query. Please provide one example of the issue.

Thank You,
Dhanik

Reply

Leave a Comment