How to upload .tsv/.xls file to custom question answering knowledge base automatically (programatically)?

Question

I am new to Azure services, and I have built a basic FAQ Bot using Custom Question Answering (CQA) of the Language service. I uploaded a manually modified .xls file using the 'import as Excel' option in [Language Studio -> CQA] for populating the Knowledge Base (KB). The bot works as intended but now I am looking at automating the solution. I would like to know how to upload the .xls file (which is either stored locally or in some azure blob storage) automatically (via REST or API calls) and update the KB.

This article from official documentation on format guidelines for CQA seems to mention that only manual import is possible for .tsv/.xls files, unless I am mistaken.

So can we automatically add excel file? If so, how?

Answer 1

Hello @Vinod Sampath , Thanks for using Microsoft Q&A Platform.

Did you get a chance to check the custom question answering Rest API documentation? https://learn.microsoft.com/en-us/azure/ai-services/language-service/question-answering/quickstart/sdk?tabs=windows&pivots=rest

Import documentation: https://learn.microsoft.com/en-us/rest/api/language/question-answering-projects/import?view=rest-language-2023-11-15-preview&tabs=HTTP

https://learn.microsoft.com/en-us/rest/api/cognitiveservices/questionanswering/question-answering-projects/import?view=rest-cognitiveservices-questionanswering-2021-10-01&tabs=HTTP

Here is the similar thread you can refer to :https://github.com/MicrosoftDocs/azure-docs/issues/92169#issuecomment-1112233750

I hope this helps.

Regards,

Vasavi

-Please kindly accept the answer and vote 'yes' if you feel helpful to support the community, thanks.