Microsoft Dynamics 365 | Integration, Dataverse...

Call external URL fetch data

(0) Share

Report

Posted on by ALAN365

Hi Experts,

I am writing JavaScript to fetch data from a logic app endpoint. The code like below:

function DynamicFlyoutMenu(commandProperties) {

debugger;

var templates = []; //global templates variable

const requestOptions = {

method: 'POST',

headers: { 'Content-Type': 'application/json' },

body: JSON.stringify({ get_templates: 'Yes' })

};

fetch('prod-16.canadaeast.logic.azure.com:xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx', requestOptions)

.then(response => response.json())

.then(data => {

alert(JSON.stringify(data));

for (const key in data) {

console.log(`${JSON.stringify(data[key])}`) //access values

for (var i in data)

templates.push([data[i]]);

templates = templates[0][0];

}

})

==========================================================

I need to get the template array, but when I run the script, the templates still empty, but the alert display the data like below

{"all-template-data":
[
{"templateName":"Temp001.docx","templateId":"DOC001"},
{"templateName":"Temp002.docx","templateId":"DOC002"},
{"templateName":"Temp003.docx","templateId":"DOC003"}
]
}

Can you help to suggest correct code? Thanks.

I have the same question (0)

All responses (4)

Answers (0)

Sort by

Suggested answer

Steve Zhao2 Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi ALL365,

Your code is correct. You say that the templates still empty. S0, where do you console the templates, inside the then() or outside?

if you console the templates array inside the then() like this:

function DynamicFlyoutMenu(commandProperties) {

    debugger;

    var templates = []; //global templates variable

    const requestOptions = {

        method: 'POST',

        headers: { 'Content-Type': 'application/json' },

        body: JSON.stringify({ get_templates: 'Yes' })

    };

    fetch('prod-16.canadaeast.logic.azure.com:xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx', requestOptions)

        .then(response => response.json())

        .then(data => {

            alert(JSON.stringify(data));

            for (const key in data) {

                console.log(`${JSON.stringify(data[key])}`) //access values

                for (var i in data)

                    templates.push([data[i]]);

                templates = templates[0][0];

            }

console.log(templates);

        })

}

It should work fine.

If outside, it could cause synchronization issues. You need to use async/await to resolve this.

Was this reply helpful? Yes No
ALAN365 2 on at

Like (0)

Report
Copy link

Link copied!

Thank you Steve.

As per your suggestion, I added console.log(templates); in then() and run the code, here is debug result:

templates array is still empty. How to fix it? Thanks

Was this reply helpful? Yes No
ALAN365 2 on at

Like (0)

Report
Copy link

Link copied!

Hi,

Have an idea, please.

Was this reply helpful? Yes No
ALAN365 2 on at

Like (0)

Report
Copy link

Link copied!

I have wrapped up the code in a HTML file to test, the code like below:

<html>

<head>

<meta content="text/html; charset = ISO-8859-1" http-equiv="content-type">

<script src="ajax.googleapis.com/.../script>

<script type="application/javascript">

function loadJSON() {

debugger;

var url = "prod-xx.canadaeast.logic.azure.com:xxxxxxxxxxxxxxxxxxxxxxxxxx;

// var params = {

// "get_templates": "Yes"

// }

var templates = []; //global templates variable

const requestOptions = {

method: 'POST',

headers: {

'Content-Type': 'application/json'

},

body: JSON.stringify({

get_templates: 'Yes'

})

};

fetch(url, requestOptions)

.then(response => response.json())

.then(data => {

alert(JSON.stringify(data));

for (var i in data)

templates.push([data[i]]);

templates = templates[0][0];

console.log(templates);

})

}

</script>

<title>Document Generation</title>

</head>

<body>

<h1>Template Info</h1>

<div class="central">

<button type="button" onclick="loadJSON()">Show Info </button>

</div>

<div id="templateName"></div>

<div id="templateId"></div>

</body>

</html>

Cannot get templates value. Please give me advice. Thanks.

Was this reply helpful? Yes No