JsonString to Object in VB6

Question

So I need to convert following response from Httprequest of JsonString to Object. Can someone help in looping it to an object. [New to Vb6]

Please see the below Json response.

{
    "Participants": [
    {
      "Participant": {
        "EntityHierarchy": {},
        "ProviderPlatform": "string",
        "ProviderPlatformDetail": [
          {
            "ProviderPlatform": "string",
            "Primary": true
          }
        ],
        "FirstName": "string",
        "LastName": "string",
        "BusinessName": "string",
        "City": "string",
        "Region": "string",
        "PostalCode": "string",
        "Phone": "string",
        "CountryCode": "string",
        "Email": "string",
        "AccountNumber": "string",
        "Active": true,
        "PSuiteAttribute": "string",
        "ParticipantIdentifier": "string",
        "SystemParticipantIdentifier": "string",
        "ITAIdentifier": "string"
        },
       "Platform": "string",
       "Program": "string",
       "ProgramFriendlyName": "string",
       "EnterpriseServicesIdentifier": "string",
       "IdentityMapped": true,
       "MappedToMasterPlatform": true,
       "MasterPlatform": "string",
       "SupportingPlatform": "string",
       "MasterPlatformName": "string",
       "SupportingPlatformName": "string",
       "FaultedMessages": [
       "string"
       ]
}

Chel · Accepted Answer · 2017-05-16 20:48:03Z

1

Bruce McPherson makes heavy use of a class called cJobject to do JSON handling in VBA/VB6. cJobject is too big to fit in an answer, but you can get its current source code off GitHub. See also his usage notes.

answered May 16, 2017 at 20:48

Chel

2,6231 gold badge20 silver badges25 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Bob77 · Accepted Answer · 2017-05-17 00:23:59Z

1

There are plenty of JSON classes floating around written in VB6, VBA, or VB6 that is portable to VBA.

Here are a couple more:

JsonBag, Another JSON Parser/Generator

JNode - JSON revisited

answered May 17, 2017 at 0:23

Bob77

13.3k1 gold badge31 silver badges37 bronze badges

Collectives™ on Stack Overflow

JsonString to Object in VB6

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related