Cannot upload Bing Spatial Data Services file using pipe delimited format RRS feed

  • Question

  • If I use commas to delimit a file, everything works fine. However, if I use a '|' (pipe) symbol instead, I get the following error:

    <?xml version="1.0" encoding="utf-8"?><Response xmlns:xsd="" xmlns:xsi="" xmlns=""><Copyright>Copyright © 2015 Microsoft and its suppliers. All rights reserved. This API cannot be accessed and the content and any results may not be used, reproduced or transmitted in any manner without express written permission from Microsoft Corporation.</Copyright><BrandLogoUri></BrandLogoUri><StatusCode>400</StatusCode><StatusDescription>Bad Request</StatusDescription><AuthenticationResultCode>ValidCredentials</AuthenticationResultCode><ErrorDetails><string>Error in parsing schema. Please verify file format.</string></ErrorDetails><TraceId>0aa696bf63954a2da3e1facaffaf23a9|DB40060233||</TraceId><ResourceSets /></Response>

    The documentation shows that pipes should be an allowed delimiter:

    Even the sample on this website causes the error above.

    Using comma delimited files is problematic because commas are commonly used in data fields. I therefore have to encode them which is not ideal as the consumer of the data then has to decode.

    Bradley Cotier

    Thursday, July 16, 2015 4:08 PM


  • Pipe's are supported. A couple of things to check:

    • The first line that has the schema info is still using commas and not pipes. That line isn't meant to only have commas in it.
    • Also check that the first line in your file doesn't have trailing delimiters. Sometimes when exporting data from Excel it will add a bunch of extra delimiter characters at the end of the first line.
    • If the above two don't work, it's possible that somewhere there is an issue in the file. Scroll to the end of it and make sure that all the data is in there and that the file isn't missing half a row at the end. If it is missing half a row then there was likely an issue when saving the file initially.
    • If you still have issues try removing half the rows and see if the upload works. Repeat this process until it does. This will help you narrow down which row in your data is causing the issue. It's possible that you had a cell that contained a comma that was in some text, and when switching to pipe you replaced that character and maybe removed the quote characters. If this was done that row will have an extra column when compared to the header and be the cause of your issue.

    Thursday, July 16, 2015 6:04 PM