Forum Discussion

Advisor

2 years ago

As far as anyone knows is there a way to transfer posts, etc., from PROD to STAGE

Has anyone come up with a script to do this? Querying Production and Posting to stage with either curl or the API? It would just be nice to be able to populate more and more realistic content on the...

2 years ago

I think maybe we're misunderstanding each other a little. When you say embed the cURL call, cURL is how you would make an API call from the command line. You wouldn't use cURL inside a Khoros component. You would use restBuilder or rest or restadmin to make the same API call with freemarker. Or if you were using JavaScript, you would use fetch maybe or XMLHttpRequest. So, I think when you say "cURL call" you are referring to the same thing I mean when I say "API call".

The examples I shared are making those calls embedded in a component.

I will take the cURL example from here Create message (khoros.com) and rewrite it using restBuilder so you can see what I mean.

So here is an example with cURL from the link above.

curl -L -X POST 'https://[COMMUNITY-DOMAIN]/api/2.0/messages/' \
-H 'Content-Type: application/json' \
-H 'Li-Api-Session-Key: [SESSION-KEY]' \
--data-raw '{
    "data": {
        "type": "message",
        "board": {
            "id": "runningShoes"
        },
        "subject": "Alternative to Saucony Ride 10 GTX",
        "body": "I have the Saucony Ride 9 and got the Saucony Ride 10 GTX, but it feels very stiff while running - not much comfort/cushion while running and uncomfortable. I originally switched to Saucony because it was very comfortable and lightweight. suggestions for Saucony running shoes for women? I run only about 10mi/wk. <li-image id=\"336i254DB2339\"/>",
        "tags": {
            "items": [
                {
                    "text": "trail running"
                },
                {
                    "text": "running shoes"
                }
            ]
        },
        "labels": {
            "items": [
                {
                    "id": "womensRunningShoes",
                    "text": "Womens Running Shoes"
                },
                {
                    "id": "recommendations",
                    "text": "Recommendations"
                }
            ]
        },
        "products": {
            "items": [
                {
                    "id": "sauconyRide10gtx"
                },
                {
                    "id": "sauconyFreedomIso"
                }
            ],
            "list_item_type": "product"
        }
    }
}'

Here is my (untested) attempt to rewrite with restBuilder which you could include in a component.

<#assign messagePostCall = restBuilder()
   .method("POST")
   .path("/messages")
   .version("v2")
   .header("Content-Type","application/json")
   .header("Li-Api-Session-Key","[SESSION-KEY]")
   .body({
        "type": "message",
        "board": {
            "id": "runningShoes"
        },
        "subject": "Alternative to Saucony Ride 10 GTX",
        "body": "I have the Saucony Ride 9 and got the Saucony Ride 10 GTX, but it feels very stiff while running - not much comfort/cushion while running and uncomfortable. I originally switched to Saucony because it was very comfortable and lightweight. suggestions for Saucony running shoes for women? I run only about 10mi/wk. <li-image id=\"336i254DB2339\"/>",
        "tags": {
            "items": [
                {
                    "text": "trail running"
                },
                {
                    "text": "running shoes"
                }
            ]
        },
        "labels": {
            "items": [
                {
                    "id": "womensRunningShoes",
                    "text": "Womens Running Shoes"
                },
                {
                    "id": "recommendations",
                    "text": "Recommendations"
                }
            ]
        },
        "products": {
            "items": [
                {
                    "id": "sauconyRide10gtx"
                },
                {
                    "id": "sauconyFreedomIso"
                }
            ],
            "list_item_type": "product"
        }
    }) />

<#assign resp = messagePostCall.call() />

So, to compare the two:

First line from cURL lists "POST" as the method which goes in "method" on restbuilder.
Also from the first line of the cURL example is the URL 'https://[COMMUNITY-DOMAIN]/api/2.0/messages/'. Because you are inside a Khoros component you don't need to include the community domain. You also don't need to include api/2.0 as that is covered by the ".version" in restBuilder. So, all you need from the URL is the /messages which goes in the "path" on restBuilder.
Next the content type and session key would go under .header in restBuilder.
Lastly the "data" from cURL would be the .body in restBuilder.

Some additional notes. You don't actually need the .version("v2") here because v2 is the default. You really only need it if you are using API v1.

Also, because you are in a component, you don't really need a session key. If you are logged in Khoros knows who you are. I included it just so you could see everything from the cURL example.

Finally, if you want to make this call with admin permissions, you would add ".admin(true)" to the restBuilder.

Complete Example:

As mentioned in a previous post I was working on a component to create an abuse report. This is very similar to posting a regular message and I can share it here. This has two parts. First, a custom endpoint created in studio which is where I use restBuilder to make the API call to create the abuse report. Second, a custom compnent which I added to the "Content Archived Page". This component calls the custom endpoint I made when a button is clicked and passes along the message id.

Endpoint Code

<#assign messageId = http.request.parameters.name.get("id", "") />
<#assign path = "messages/" + messageId + "/abuse_reports" />

<#if config.getString("phase", "prod") == "stage">
    <#assign body = "***UNARCHIVE REQUEST***  https://community.stage.ptc.com/t5/contentarchivals/viewpage/message-uid/" + messageId />
<#else>
    <#assign body = "***UNARCHIVE REQUEST***  https://community.ptc.com/t5/contentarchivals/viewpage/message-uid/" + messageId />
</#if>

<#assign unarchiveCall = restBuilder()
   .method("POST")
   .path("${path}")
   .body({
        "data":{
            "type":"abuse_report",
            "body":"${body}"
        }
    })
   .admin(true) />
<#assign resp = unarchiveCall.call() />

{
    "http_code":"${resp.http_code}",
    "status" : "${resp.status}"
}

Component Code

<div id="unarchive-button-container-ak">
    <span class="lia-button lia-button-primary" id="unarchive-button-ak">Request Unarchive</span>
</div>

<div id="result-message-ak"></div>

<style>
    div#result-message-ak {
        margin-top: 20px;
    }

    #result-message-ak p {
        padding: 10px;
        font-size: 16px;
        text-align: center;
    }

    div#unarchive-button-container-ak {
        width: 194px;
        margin-left: auto;
        margin-right: auto;
    }
</style>

<@liaAddScript>
    ;(function($) {

        const unarchiveButton = document.getElementById('unarchive-button-ak');

        unarchiveButton.addEventListener("click", () => {
            const loc = window.location.pathname;
            const locArray = loc.split("/");
            const messageID = locArray[locArray.length - 1];
            console.log(messageID);
            const resultMessage = document.getElementById('result-message-ak');

            const url = '/sejnu66972/plugins/custom/ptc/ptc1/unarchive?id=' + messageID

            async function unarchiveRequest(url) {
                const response = await fetch(url, {
                    method: "POST",
                    headers: {
                        "Content-Type": "application/json"
                    }
                })

                const result = await response.json();

                console.log(result);

                if (result.status == "success") {
                    resultMessage.innerHTML = "<p>Your request was successfully sent. You should hear from a moderator within 24 business hours.</p>"
                } else {
                    resultMessage.innerHTML = "<p>There was a problem sending your request. Please try again later or contact the community team directly at community@ptc.com</p>"
                }
            }

            unarchiveRequest(url);
        })

    })(LITHIUM.jQuery);
</@liaAddScript>

Sorry for the wall of text. Again, hopefully that's not too much info. Also, sorry there are no comments in my code let me know if you have any questions.

isxtn

Advisor

Could you do me the favor of showing me a simple example in place in a Freemarker custom component?

Thanks

Akenefick

Genius

2 years ago

Sure. There are a few different ways to make an API call inside a Khoros component with freemarker. If you have a body like when creating a message, I like to use restBuilder. The restBuilder documentation has an example of this. I'll share it below.

<#assign messagePostCall = restBuilder()
   .method("POST")
   .path("/messages")
   .body({
            "type": "message",
            "board": {
                "type": "board",
                "id": myBoard
            },
            "subject": "Test Message",
            "body": "This is a test"
        })
   .admin(true) />
<#assign resp = messagePostCall.call() />

Something to keep in mind, freemarker runs server side before the page loads. So, if you need any user input you have to use javascript. You can put your freemarker in a custom endpoint About endpoints (khoros.com) which is maybe getting a little advanced if you are just getting started with Khoros.

Khoros has other freemarker objects for making API calls you can use as well.

restadmin and liqladmin are just like rest and liql, but they make the calls with admin permissions. Keep in mind you don't need to authenticate from inside a khoros component because the community knows you are logged in and who you are. However, that means it will only let you do things you have permission for, so if you are making a component that will be accessible by regular members, but you need to do something that requires admin permissions you would use the restadmin version. Just be careful not to accidently reveal private info or anything to regular community members.

Also, I'm not sure if you are familiar with LiQL yet. It lets you get information with a query formatted like this.

SELECT author.id FROM messages WHERE board.id = 'xyz'

liql and liqladmin let you do that very easily, so if you use LiQL a lot they are very handy. For example, from the documentation:

Compare liql call to the rest call:
rest("2.0","/search?q=" + "SELECT id, subject, body FROM messages ORDER BY post_time DESC LIMIT 5"?url)

with liql call:

liql("SELECT id, subject, body FROM messages ORDER BY post_time DESC LIMIT 5")

Something else to keep in mind, you can use any of the typical web development stuff in a component too. So, if you wanted to or if the situation demanded it, you could also use JavaScript to make API calls. You can use a regular script tag and add JavaScript like you would in HTML or use liaAddScript (khoros.com) which is what I usually do. It is freemarker provided by Khoros for that purpose. However, then you wouldn't have access to restadmin or anything like that and you need to keep in mind permissions and who is going to be using the component.

Hopefully that's not too much information. I would start with something simple for practice and then go from there. The documentation can be hard to navigate but I lean heavily on it. Once you learn your way around there it is very useful.

isxtn

Advisor

2 years ago

Thanks, that's excellent information. I am familiar with LiQL but I appreciate the details, and thanks for the example.

I still can't figure out how to embed the cURL call though. Thoughts or examples on that?

Akenefick

Genius

2 years ago

The examples I shared are making those calls embedded in a component.

I will take the cURL example from here Create message (khoros.com) and rewrite it using restBuilder so you can see what I mean.

So here is an example with cURL from the link above.

curl -L -X POST 'https://[COMMUNITY-DOMAIN]/api/2.0/messages/' \
-H 'Content-Type: application/json' \
-H 'Li-Api-Session-Key: [SESSION-KEY]' \
--data-raw '{
    "data": {
        "type": "message",
        "board": {
            "id": "runningShoes"
        },
        "subject": "Alternative to Saucony Ride 10 GTX",
        "body": "I have the Saucony Ride 9 and got the Saucony Ride 10 GTX, but it feels very stiff while running - not much comfort/cushion while running and uncomfortable. I originally switched to Saucony because it was very comfortable and lightweight. suggestions for Saucony running shoes for women? I run only about 10mi/wk. <li-image id=\"336i254DB2339\"/>",
        "tags": {
            "items": [
                {
                    "text": "trail running"
                },
                {
                    "text": "running shoes"
                }
            ]
        },
        "labels": {
            "items": [
                {
                    "id": "womensRunningShoes",
                    "text": "Womens Running Shoes"
                },
                {
                    "id": "recommendations",
                    "text": "Recommendations"
                }
            ]
        },
        "products": {
            "items": [
                {
                    "id": "sauconyRide10gtx"
                },
                {
                    "id": "sauconyFreedomIso"
                }
            ],
            "list_item_type": "product"
        }
    }
}'

Here is my (untested) attempt to rewrite with restBuilder which you could include in a component.

<#assign messagePostCall = restBuilder()
   .method("POST")
   .path("/messages")
   .version("v2")
   .header("Content-Type","application/json")
   .header("Li-Api-Session-Key","[SESSION-KEY]")
   .body({
        "type": "message",
        "board": {
            "id": "runningShoes"
        },
        "subject": "Alternative to Saucony Ride 10 GTX",
        "body": "I have the Saucony Ride 9 and got the Saucony Ride 10 GTX, but it feels very stiff while running - not much comfort/cushion while running and uncomfortable. I originally switched to Saucony because it was very comfortable and lightweight. suggestions for Saucony running shoes for women? I run only about 10mi/wk. <li-image id=\"336i254DB2339\"/>",
        "tags": {
            "items": [
                {
                    "text": "trail running"
                },
                {
                    "text": "running shoes"
                }
            ]
        },
        "labels": {
            "items": [
                {
                    "id": "womensRunningShoes",
                    "text": "Womens Running Shoes"
                },
                {
                    "id": "recommendations",
                    "text": "Recommendations"
                }
            ]
        },
        "products": {
            "items": [
                {
                    "id": "sauconyRide10gtx"
                },
                {
                    "id": "sauconyFreedomIso"
                }
            ],
            "list_item_type": "product"
        }
    }) />

<#assign resp = messagePostCall.call() />

So, to compare the two:

First line from cURL lists "POST" as the method which goes in "method" on restbuilder.
Also from the first line of the cURL example is the URL 'https://[COMMUNITY-DOMAIN]/api/2.0/messages/'. Because you are inside a Khoros component you don't need to include the community domain. You also don't need to include api/2.0 as that is covered by the ".version" in restBuilder. So, all you need from the URL is the /messages which goes in the "path" on restBuilder.
Next the content type and session key would go under .header in restBuilder.
Lastly the "data" from cURL would be the .body in restBuilder.

Some additional notes. You don't actually need the .version("v2") here because v2 is the default. You really only need it if you are using API v1.

Also, because you are in a component, you don't really need a session key. If you are logged in Khoros knows who you are. I included it just so you could see everything from the cURL example.

Finally, if you want to make this call with admin permissions, you would add ".admin(true)" to the restBuilder.

Complete Example:

Endpoint Code

<#assign messageId = http.request.parameters.name.get("id", "") />
<#assign path = "messages/" + messageId + "/abuse_reports" />

<#if config.getString("phase", "prod") == "stage">
    <#assign body = "***UNARCHIVE REQUEST***  https://community.stage.ptc.com/t5/contentarchivals/viewpage/message-uid/" + messageId />
<#else>
    <#assign body = "***UNARCHIVE REQUEST***  https://community.ptc.com/t5/contentarchivals/viewpage/message-uid/" + messageId />
</#if>

<#assign unarchiveCall = restBuilder()
   .method("POST")
   .path("${path}")
   .body({
        "data":{
            "type":"abuse_report",
            "body":"${body}"
        }
    })
   .admin(true) />
<#assign resp = unarchiveCall.call() />

{
    "http_code":"${resp.http_code}",
    "status" : "${resp.status}"
}

Component Code

<div id="unarchive-button-container-ak">
    <span class="lia-button lia-button-primary" id="unarchive-button-ak">Request Unarchive</span>
</div>

<div id="result-message-ak"></div>

<style>
    div#result-message-ak {
        margin-top: 20px;
    }

    #result-message-ak p {
        padding: 10px;
        font-size: 16px;
        text-align: center;
    }

    div#unarchive-button-container-ak {
        width: 194px;
        margin-left: auto;
        margin-right: auto;
    }
</style>

<@liaAddScript>
    ;(function($) {

        const unarchiveButton = document.getElementById('unarchive-button-ak');

        unarchiveButton.addEventListener("click", () => {
            const loc = window.location.pathname;
            const locArray = loc.split("/");
            const messageID = locArray[locArray.length - 1];
            console.log(messageID);
            const resultMessage = document.getElementById('result-message-ak');

            const url = '/sejnu66972/plugins/custom/ptc/ptc1/unarchive?id=' + messageID

            async function unarchiveRequest(url) {
                const response = await fetch(url, {
                    method: "POST",
                    headers: {
                        "Content-Type": "application/json"
                    }
                })

                const result = await response.json();

                console.log(result);

                if (result.status == "success") {
                    resultMessage.innerHTML = "<p>Your request was successfully sent. You should hear from a moderator within 24 business hours.</p>"
                } else {
                    resultMessage.innerHTML = "<p>There was a problem sending your request. Please try again later or contact the community team directly at community@ptc.com</p>"
                }
            }

            unarchiveRequest(url);
        })

    })(LITHIUM.jQuery);
</@liaAddScript>

Sorry for the wall of text. Again, hopefully that's not too much info. Also, sorry there are no comments in my code let me know if you have any questions.

isxtn
Advisor
2 years ago
Thank you so much Andrew! That was all very very helpful. Khoros should hire you to rewrite its documentation clearly 🤣
I assume if I needed it, I could find the session key in the cookie for LiSESSIONID, or have they somehow hidden it elsewhere named something completely unrelated because that would make too much sense? Also 🤣
And what is PTC?

Forum Discussion

As far as anyone knows is there a way to transfer posts, etc., from PROD to STAGE

Related Content

New CSM anyone?

400/404 error on POST request

Does anyone know how to change the display title of Custom Fields in Aurora?

Aurora: Create Post Button widget configuration

Aurora: Publish blog posts

Recent Discussions

Error while fetching products data using graphql query

Google Tag Manager and Google Analytics Setup in Aurora platform

Using LiQL or SQL on Aurora instead of GraphQL?

Not receiving user email addresses from search endpoint

Dynamic Values in custom fields into Aurora