Api for json import to dataset

Hello
I am new on Xibo. I will but a sharepoint table in xibo cms as dataset.
Since now i am able to export the sharepoint table to excel an to autoupdate. From excel o csn make a json via vba but Api is new for me.
What i have to do for automaticaly import the json as dataset in xibo?

Thanks Harald