Microsoft Graph API error: Access token validation failure. Invalid audience.

Question

Hello,

I am encountering a small problem with the API key. I would like to fetch data from a file located in a SharePoint library using JavaScript.

I created an application on SharePoint and granted it the following permissions:

**

I used Postman to generate an access token, but when I try to use this access token, it doesn't work either on Postman or in JavaScript.

I successfully generated an access token, but when I try to use it, I encounter an error.

1. Error on Postman:

2. Error on JS (Here is my JavaScript code:

Could you please help me resolve this issue? Thank you.

Answer 1

Hi @MOUSSAOUI Mohammed

The 00000002-0000-0000-c000-000000000000 is the application ID for Azure AD Graph API, which has been deprecated and cannot be used to call MS Graph API. You should request a token for MS Graph API, please follow this documentation.

Additionally, if the audience of the token you request in JS is MS Graph API, do not apply it to SharePoint REST API, otherwise it will still throw a 401 error.

Hope this helps.

If the reply is helpful, please click Accept Answer and kindly upvote it. If you have additional questions about this answer, please click Comment.

Answer 2

................

Answer 3

Can you tell me how to do this please, it's the first time I've used this.

$(document).ready(function() {
  fetchCSV();
});

async function fetchCSV() {
  const siteUrl = "https://awex.sharepoint.com";
  const fileUrl = "/sites/Intranet/Documents%20partages/AdUserlast180days.csv";
  const accessToken = ''; 
  
  try {
    const response = await fetch(`${siteUrl}/_api/web/GetFileByServerRelativeUrl('${fileUrl}')/$value`, {
  method: 'GET',
  headers: {
    'Authorization': 'Bearer ' + accessToken,
    'Accept': 'text/csv',
  },
  mode: 'no-cors' 
});

    if (!response.ok) {
      throw new Error(`Erreur HTTP ! Statut : ${response.status}`);
    }

    const csvData = await response.text();
    console.log(csvData); 
    console.log('Fichier chargé avec succès');

    // Traitez le CSV si nécessaire
    // Par exemple, utilisez PapaParse pour l'analyser
    // const parsedData = Papa.parse(csvData, { header: true });
    // console.log(parsedData);

  } catch (error) {
    console.error('Erreur lors de la récupération du fichier CSV :', error);
  }
}