This question already has an answer here:

Could you tell me what are the Data Extensions used by Web & Mobile Analytics where i cand find data collected from Javascript in website? I should retrieve data using firstly a SOAP UI Call, then a SQL query in a child Business Unit of MC Account.

marked as duplicate by Eliot Harper, Mohith Shrivastava, Lance Shi, martin, Adam Spriggs Jan 22 '17 at 12:42

This question has been asked before and already has an answer. If those answers do not fully address your question, please ask a new question.

  • Thanks i've retrieved data from PI Data Extensions using this API Call [developer.salesforce.com/docs/atlas.en-us.mc-apis.meta/mc-apis/…; anyway i cannot retrieve data from PI Data Extension of child business Unit. – cmbob Jan 22 '17 at 9:41
  • Yes, once you know the DE names (which I've provided here) then you can retrieve the fields using the API, and once you know the fields, then you should be able to use the DE name and fields in a query. – Eliot Harper Jan 22 '17 at 9:43
  • In the api call i added this code in order to specify different Business Units <RetrieveRequestMsg xmlns="http://exacttarget.com/wsdl/partnerAPI"><RetrieveRequest><Client><ID>XXXXXX</ID></Client><ObjectType>DataExtensionObject[IGO_PRODUCTATTRIBS]</ObjectType><Properties>attribName</Properties><Properties>attribValue</Properties></RetrieveRequest></RetrieveRequestMsg> ; but the response is always the same. – cmbob Jan 22 '17 at 9:48