Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Create CSV to JSON Converter #18

Open
darnjo opened this issue Feb 3, 2023 · 0 comments
Open

Create CSV to JSON Converter #18

darnjo opened this issue Feb 3, 2023 · 0 comments
Assignees
Labels
enhancement New feature or request
Milestone

Comments

@darnjo
Copy link
Member

darnjo commented Feb 3, 2023

The Batch Ingest API uses records in JSON format, which are represented by an array of ULI payload items. For example:

POST http://localhost/uli-service/v1/ingest/M0000033
[
    {
        "MemberFullName": "ohai2 ohai",
        "MemberLastName": "ohai",
        "MemberFirstName": "ohai2",
        "MemberMiddleInitial": "ohai",
        "MemberNickname": "ohai",
        "MemberType": "ohai",
        "MemberNationalAssociationId": "ohai",
        "MemberStateLicense": "ohai",
        "MemberStateLicenseType": "ohai",
        "MemberStateLicenseState": "ohai",
        "MemberMlsId": "ohai",
        "OfficeName": "ohai",
        "OfficeMlsId": "ohai",
        "SourceSystemID": "ohai",
        "SourceSystemName": "ohai",
        "OriginatingSystemID": "ohai",
        "OriginatingSystemName": "ohai"
    }
]

In order to make it easier for people to test the system, the UI should allow the user to upload a CSV file with membership data matching the ULI Template Schema.

This means that data will need to be converted from CSV to JSON either on the client side, before submitting it to the Batch Ingest API, or the Ingest API will need to be extended to support CSV.

There are two possibilities if the functionality is implemented on the API: a) either the endpoint could be the same (in which case the function would have to check the content type and convert if CSV, otherwise use JSON), or b) a different URL could be used. Using the same URL is probably preferable if this is to be done on the ULI API rather than UI.

@darnjo darnjo added the enhancement New feature or request label Feb 3, 2023
@darnjo darnjo added this to the Bulk Ingest milestone Feb 3, 2023
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
enhancement New feature or request
Projects
None yet
Development

No branches or pull requests

2 participants