How to Get Data From Web Application into Power BI

HI Anonymous ,

Please check the following custom functions if it is suitable for your requirements. (notice: I do not have vailed apikey to test, so you need to modify following code if it structure not suitable for its develop document)

Custom function:

let
    InvokeApi=(apikey as text, relativepath as text,optional content as text) =>
    let
        rooturl = "https://api.nookal.com",
        AccessTokenHeader = apikey,
        GetJsonQuery =
        if 
            content=null 
        then 
            Web.Contents(rooturl,
                [
                    Headers = [#"apiKey"=AccessTokenHeader,
                    #"Content-Type"="application/x-www-form-urlencoded; charset=UTF-8"],
                    RelativePath=relativepath
                ]
            )
        else
            Web.Contents(rooturl,
            [
                Headers = [#"apiKey"=AccessTokenHeader,
                #"Content-Type"="application/x-www-form-urlencoded; charset=UTF-8"],
                RelativePath=relativepath,
                Content = Text.ToBinary(content) 
            ]
        )
        ,
        Result = Binary.From(GetJsonQuery)
    in
        Result
 in
    InvokeApi

ApiDictionary:

let
    Source =  [      
        //Basic Verification Tools
        version                   = "/production/v2/version",
        verify                    = "/production/v2/verify",
        //Basic Retrieval tools (locations, practitioners)
        locations                 = "/production/v2/getLocations",
        practitioners             = "/production/v2/getPractitioners",
        //Retrieve Services/Stock/Inventory elements
        classTypes                = "/production/v2/getClassTypes",
        serviceTypes              = "/production/v2/getAppointmentTypes",
        stockList                 = "/production/v2/getStockList",
        //Get Availabilities
        appointmentAvailability   = "/production/v2/getAppointmentAvailabilities",
        classAvailability         = "/production/v2/getClassAvailabilities",
        getClasses                = "/production/v2/getClasses",
        getClassParticipants      = "/production/v2/getClassParticipants",
        //Add/Modify Bookings
        addBooking                = "/production/v2/addAppointmentBooking",
        addClassBooking           = "/production/v2/addClassBooking",
        cancelAppointment         = "/production/v2/cancelAppointment",
        rebookAppointment         = "/production/v2/rebookAppointment",
        //Patient Tools
        patients                  = "/production/v2/getPatients",
        searchPatients            = "/production/v2/searchPatients",
        addPatient                = "/production/v2/addPatient",
        addTreatmentNote          = "/production/v2/addTreatmentNote",
        invoices                  = "/production/v2/getInvoices",
        treatmentNotes            = "/production/v2/getTreatmentNotes",
        cases                     = "/production/v2/getCases",
        files                     = "/production/v2/getPatientFiles",
        fileUrl                   = "/production/v2/getFileUrl",
        //File uploading components (requires both calls to make the file go live)
        upload                    = "/production/v2/uploadFile",
        activateFile              = "/production/v2/setFileActive",
        //Logos
        locationLogo              = "/production/v2/getLocationLogo",
        practitionerPhoto         = "/production/v2/getPractitionerPhoto",
        //Large pull requests (site backup requests)
        appointments              = "/production/v2/getAppointments",
        allTreatmentNotes         = "/production/v2/getAllTreatmentNotes",
        allInvoices               = "/production/v2/getAllInvoices",
        //Custom Requests (requires special API on the Nookal interface side)
        practitionerTypes         = "/production/v2/getPractitionerAppointmentTypes",
        serviceMatrix             = "/production/v2/getServiceMatrix",
        //Invoices 
        addInvoice                = "/production/v2/addInvoice",
        addItemToInvoice          = "/production/v2/addItemToInvoice",
        addPaymentToInvoice       = "/production/v2/addPaymentToInvoice",
        deleteItemFromInvoice     = "/production/v2/deleteItemFromInvoice",
        deletePaymentFromInvoice  = "/production/v2/deletePaymentFromInvoice",
        deleteInvoice             = "/production/v2/deleteInvoice",
        getInvoice                = "/production/v2/getInvoice",
        getExtras                 = "/production/v2/getExtras",
        addExtra                  = "/production/v2/addPatientExtra"
		]
in
    Source

Invoke function:

let
    Source = InvokeApi("xxxxxx", ApiDictionary[verify], null)
in
    Source

Regards,

Xiaoxin Sheng