Puzzling Reporting Responses

I've submitted a SOAP request that worked last week, but when I run it today (and yesterday), I get error code -400063, The report data for the requested date range is not yet available.  However, I know that the report data is available, because I got it last week.  I've included my SOAP below.

Thanks.
SOW

REQUEST
< xml version="1.0" encoding="utf-8" >
        <soap:Envelope xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/">
        <soap:Header>
        <ApiUserAuthHeader xmlns="http://adcenter.msn.com/syncapis">
  <UserName>*****</UserName>
  <Password>*****</Password>
  <UserAccessKey>*****</UserAccessKey>
</ApiUserAuthHeader>
        </soap:Header>
        <soap:Body>
        <RequestBIReport xmlns="http://adcenter.msn.com/syncapis">
        <APIFlags>0</APIFlags><request xsi:type="KeywordPerformanceReportRequest"><ReportDates><dateTime>2006-08-18</dateTime></ReportDates><ReportLanguage>English</ReportLanguage><Format>CSV</Format><AllNone>1</AllNone><ReportAggregation>Day</ReportAggregation><AccountId>35255</AccountId></request>
        </RequestBIReport>
        </soap:Body>
        </soap:Envelope>



RESPONSE:
< xml version="1.0" encoding="utf-8" ><soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema"><soap:Body><soap:Fault><faultcode>soap:Server</faultcode><faultstring>Server was unable to process request. ---&gt; |-400063|-1||</faultstring><detail /></soap:Fault></soap:Body></soap:Envelope>


Answer this question

Puzzling Reporting Responses

  • Bo Yu

    Hi Sherrett, I was going through the different threads and saw that one too - your furstration is right. I can see that no one has provided any solution or right suggestion yet rather than beating about the bushes over the password thingy...

    Here are some tips. I am using mentioned below SOAP request. Please read the notes as well. If you are working on Java environment I can further help you out. What about your deadline Any success so far !

    In Message:

    <soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">

    <soapenv:Header>

    <ns1:ApiUserAuthHeader soapenv:actor="http://schemas.xmlsoap.org/soap/actor/next" soapenv:mustUnderstand="0" xmlns:ns1="http://adcenter.microsoft.com/syncapis"><ns1:UserName>****</ns1:UserName><ns1:Password>*****</ns1:Password><ns1:UserAccessKey>*****</ns1:UserAccessKey></ns1:ApiUserAuthHeader>

    </soapenv:Header>

    <soapenv:Body>

    <RequestBIReport xmlns="http://adcenter.microsoft.com/syncapis">

    <APIFlags>0</APIFlags>

    <request xsi:type="ns2:KeywordPerformanceReportRequest" xmlns:ns2="http://adcenter.microsoft.com/syncapis">

    <StartDate xsi:type="xsd:dateTime">2006-10-16T06:12:04.784Z</StartDate>

    <EndDate xsi:type="xsd:dateTime">2006-10-16T06:12:04.784Z</EndDate>

    <ReportLanguage xsi:type="ns2:ReportLanguageType">English</ReportLanguage>

    <Format xsi:type="ns2:APIResultFileType">XML</Format>

    <AllNone xsi:type="xsd:boolean" xsi:nil="true"/>

    <ReportDateRange xsi:type="ns2:ReportDateRangeType">CustomizedDataRange</ReportDateRange>

    <ReportAggregation xsi:type="ns2:ReportAggregationType">Day</ReportAggregation>

    <AccountId xsi:type="xsd:int">9999</AccountId>

    </request>

    </RequestBIReport>

    </soapenv:Body>

    </soapenv:Envelope>

    = Out message:

    < xml version="1.0" encoding="utf-8" ><soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema"><soap:Body><RequestBIReportResponse xmlns="http://adcenter.microsoft.com/syncapis"><RequestBIReportResult>2273774</RequestBIReportResult></RequestBIReportResponse></soap:Body></soap:Envelope>

    Note: 1- Please change the URL in your tag <ApiUserAuthHeader> from http://adcenter.msn.com/syncapis TO http://adcenter.microsoft.com/syncapis

    Use these URls to get the production WSDLs.:

    Administration: https://adcenterapi.microsoft.com/v3/Administration/Administration.asmx wsdl

    CampaignManagement: https://adcenterapi.microsoft.com/v3/CampaignManagement/CampaignManagement.asmx wsdl CustomerManagement: https://adcenterapi.microsoft.com/v3/CustomerManagement/CustomerManagement.asmx wsdl Reporting: https://adcenterapi.microsoft.com/v3/Reporting/Reporting.asmx wsdl

    To get the sandbox WSDLs use these URLs:

    Administration: https://beta6.api.idss.msn.com/v3/Administration/Administration.asmx wsdl

    CampaignManagement: https://beta6.api.idss.msn.com/v3/CampaignManagement/CampaignManagement.asmx wsdl

    CustomerManagement: https://beta6.api.idss.msn.com/v3/CustomerManagement/CustomerManagement.asmx wsdl

    Reporting:

    https://beta6.api.idss.msn.com/v3/Reporting/Reporting.asmx wsdl



  • prodonjs

    Hi Fahad Hanif,

    Your post is really helpful to me in working with Reporting. I sent SOAP XML request as specified by you and got this response.

    < xml version="1.0" encoding="utf-8" ><soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema"><soap:Body><RequestBIReportResponse xmlns="http://adcenter.microsoft.com/syncapis"><RequestBIReportResult>2470849</RequestBIReportResult></RequestBIReportResponse></soap:Body></soap:Envelope>

    I sent SOAP request for CSV report of keyword performance report for a single date. How can I proceed from here How can I get requested CSV data

    Please advice.

    Thanks.

    Hari Arla



  • mujadaddy

    This is your report Job Id.

    you have to now call the GetAPIReportStatus method to get the report status back, and put in a flag to check for the reponse=success. When the ReportStatus == Success, it should return you back a URL which you can then use to get your report using either the CURL package for PHP, or simply by using a wget, and saving it locally. hope this helps.


    Sample request for the GetAPIReportStatus should look like this


    '<GetAPIReportStatus xmlns="http://adcenter.microsoft.com/syncapis">
    <APIFlags>'.$apiFlags.'</APIFlags>
    <APIRequestId>'.$requestId.'</APIRequestId>
    </GetAPIReportStatus>


    Rampy

  • Paul Martin

    Please protect your username, password and access key by not sharing them in public forums. I edited your original post to mask them.

    We'll get back to your original question shortly...

    Thanks!

    Shai


  • MNJ&amp;#40;m-studio&amp;#41;

    Hello,

    After looking into this issue, I was made aware that a support escalation already exists between you and our support team (please correct me if I am wrong )

    While these forums are excellent for quick questions, sharing tips & solutions with the community and much more, it is in your best interest to pursue a support ticket when you have data that needs thorough investigation, especially when involving sensitive personal information. Additionaly, using our excellent support system, you are likely to have a very comprehensive and quick resolution to your issue.

    Please let me know if you have any further questions or comments about this; or if I can be of assistance in any other way.

    Best Regards,

    Jason - MSFT


  • Romano Jerez

    Hi Sherrett,

    Please allow me to clarify, we appreciate and sincerely encourage you and all other adCenter API developers to post on this forum; we created the forum for this very reason. Please excuse me if my post appeared as a deterrent, it was by no means meant as such; I simply want to ensure that you are aware of, and using our support resources to your best advantage

    Now, concerning the reporting issue, I have reviewed the related support ticket and I noticed that the following message has been sent to address this very issue:

    If you confer with the latest SDK and do a search for "custom report" then you will see a few results. Then Item that is ranked number 10 will be able to guide you.

    Please verify whether this resolves your issue. I will help ensure that you recieve a prompt response in the event that desire further assistance.

    Thank you for your patience and understanding.

    Best Regards,

    JasonDT - MSFT


  • Kuido Klm

    I can understand how putting your password on the web is a bad idea. That was a stupid mistake on my part.

    I don't seen any problem in asking the community "Hey, do you see anything wrong here ", even if I've asked support for assistance already, especially since I've not been able to get an answer through my support escalation. If I can get an answer from the community before I get one from support, that's OK, right While support might be duplicating effort if I do this, it's been 10 days! I'm missing a deadline, and, after 10 days, it becomes a little curious to my team why I can't get an answer to a simple question in 10 days without exhausting all channels. So, you could say that sending my email here is me trying to do just that.

    Upon review, I guess my question wasn't clearly stated.

    Does anyone see any problem with the request for reporting I've formed above I feel like the documentation doesn't specify well the reporting options, and the examples I've found at https://adcenterapi.microsoft.com/v2/Reporting/Reporting.asmx are a little generic to provide the help I need.

    Thanks in advance!
    Sherrett

  • Alexnaldo Santos

    Are you still seeing this by chance If so, let me know, I can look into this futher for you.

  • Dhondtie

    Hmm... guess I'd better change my password.

  • Puzzling Reporting Responses