parseCom. Error 401

14 views
Skip to first unread message

Gustav Gans

unread,
Apr 16, 2014, 7:49:19 PM4/16/14
to excel-r...@googlegroups.com
Hello,
this might be of interest for others but needs verification. I was trying to run the "parseCom" example. Got everything set-up on Parse.com but every time, when I run "populates", it would return me a 401 error. Double and triple checked all Id's but couldn't find anything. **sight**

After a while I decided to step through the code from the beginning and discovered that "firstTimeParseCom" writes the app id and the restapikey in the wrong sequence to the registry.

In "getRegistryPackage" I got this string: {"scopeEntry":"rest","authFlavor":"parse","restAPIKey":"Value of application id","applicationID":"Value of rest api key"}

I used this https://groups.google.com/forum/#!topic/excel-ramblings/_z8b9Gw8kws, to get the clear text key information:
Private Function encrypt(s As String) As String
    encrypt = s
End Function

Original:
Private Sub firstTimeParseCom()
    Dim parseCom As cParseCom
    Set parseCom = New cParseCom
    With parseCom.init("colortable", , , "your app id", "your restapikey")
        .tearDown
    End With
End Sub

My change:
Private Sub firstTimeParseCom()
    Dim parseCom As cParseCom
    Set parseCom = New cParseCom
    With parseCom.init("colortable", , , "your restapikey", "your app id")
        .tearDown
    End With
End Sub

After switching the app id and the rest api key, the data arrived at parse.com. Happy day!
G.

Bruce Mcpherson

unread,
Apr 17, 2014, 6:03:14 AM4/17/14
to excel-r...@googlegroups.com
nice catch - thank you .. i'll check it out


--
You received this message because you are subscribed to the Google Groups "Excel Liberation" group.
To unsubscribe from this group and stop receiving emails from it, send an email to excel-ramblin...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Reply all
Reply to author
Forward
0 new messages